I have no problems getting VB to work with a database. IT:SQL or an access db file I need to get VB to read from an XML file.Ive read several different tutorials and I cant ever get past the first few steps, I don't know what i am missing
[Code]...
every single time, how ever many tutorials ive tried i always get "type xmltextreader is not defined.I have tried just segments or all of the code they list in these tutorials, same results.
In vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
View 2 RepliesI am making a window based application in vb.net. Now i have work in two sql databases, so i when the window opens it will show two databases..when i select first db then i can work in that particular db only..if select 2nd db then i can work in second db only..how to do that?
View 1 RepliesI opened vs 2008 and used the server explorer for the first time to create a connection to my SQL 2005 db. The solution explorer pulled in all the tables, the database diagram etc. My question is how do I access that database connection and work with it using ADO objects? Do I need a reference to ADO?
View 4 Repliesadd user to access database but it's doesn't work the problem here
SavInto.ExecuteNonQuery()
say a user buys a 6 month subscription to my online app. Using c# or vb.net, How would I work out what the expiry date should be to be inserted into the database.
View 2 RepliesI am trying to pull the data by date in vb.net. It is not throwing the error nor giving any result. Whereas It shows the results in table adapter configuration wizard when I try through query builder. I am using date time picker in the form. But I have formatted the date in the database as date.
[code....]
Why would database drivers work in the development environment of VB.Net and not once the project is built and installed on the same pc? I've tried the MS ODBC Oracle driver. I've tried various ODBC datasources. All work when I am in the development environment but none once I build and install. No matter whether the configuration is Debug or Release. This is the only project having this problem. I have other apps (VB.Net) that access the same database (Oracle 9.2) with no problem.The environment variables are the same during both types of runs. The error messages vary depending upon the driver being used.
View 1 RepliesI know how to make a setup wizard but when I install my program on other computers, I get an error (SQL Error).
What do I need to install on other computers other than .NET Framework and my program ?
I made a program that i want to run on computers at school and it utalizes a MySQL database. When i try to run it the program does not work as it cannot access the database. I open the code up on my computer at school and it has errors saying ti does nto recognize the MySQL code as it does not have it in its .Net library. So i try to download it into the library but that does not work. So my question is, will programs using any kind of database not work unless the user installs the needed add on, weather it be a .Net library add on or a java add on for MySQL? That cant be right it.
View 4 RepliesI'd like to get some feedback what you think is the best way of designing a VB 2005 application that can be set up ("scaled"?) to work with different database backends (say MS-Access vs. SQL Server vs. Oracle). For example, where would you store the connection info, where should the repository of SQL statements (which will vary slightly from DBMS to DBMS) reside, etc.
View 9 Replieshow to get this login to work if i add a field in to my database called UserTypes "Admin" "Normal" if they are admin if will display cmdAdmin and if they are Normal if will hide cmdAdmin this is the code i have currently?.[code]
View 12 RepliesFor a school program, I was assigned to use a .dat file to store and edit information while using VB to be it's front end( to appear in a listbox). I was also given what field length to use per field. I never worked with .dat files, so I have a few questions (all the google-ing Ive done say the same thing: every .dat file is different so you can't play around with them):
[Code]...
My project involves making a table database that displays student number, surname, first name, homeroom, and grade avg. Through SQL commands, there must be functions to add, update, delete, search by field, and save records to the database.I have already set the database up just fine and displayed it in a DataGridView. Through the DataGridView, I was able to go to the "Add Query" area, and I successfully made the queries necessary for searching by field. However, when I try to do anything other than a search using the query builder (ie start my SQL command with INSERT INTO or DELETE FROM), I ultimately get the message "Failed to get schema for this query"For example, this SQL code (to add an entry to the database) worked when I was in the Query Builder (and the entry that it made is still in the database), but when I finally tried to confirm it, I got the "Failed to get schema for this query" message.Being unable to add entries to the database this way, I tried to do it with textboxes on a form. Each textbox will have one of the fields, and at the click of a button, they would be put into the table. My code is below. I do not know what is wrong withit. When I run it, my fields do not appear on the DataGridView immediately, but I must run the program again to see it. The time after, the entry is gone. So I am not sure how exactly such entries are to be saved.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
[code].....
my save button not work
Private Sub btn_save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_save.Click
[code].....
I have an application which connects to a database, retrieves a username from a user's table and matches it against the username retrieved with System.Security.Principal.WindowsIdentity.GetCurrent.Name.On my localhost, everything works fine. The database exists on the development server but the application lies on my localhost. All of my authorization and authentication techniques are running smoothly.However, when I publish my application to the development server, I'm faced with the following error.Cannot open database requested in login 'databaseName'. Login fails.Login failed for user 'DevelopmentServerNameASPNET'.
[Code]...
I found that when group by multiple values does not work well with VB.NET, but it works well with C# ,here are my code, is there something wrong with my VB.NET Code? Here is my VB.NET code:
[Code]...
I have an application that requires data be entered, and after entering, a button is clicked to process that data. Clicking the button works just as it should--the data is processed properly. In constructing a test module, I provide a set of data values, followed by:
btnWhatever.PerformClick()
Nothing happens. I have used this syntax for years, and it has always worked flawlessly. I have triple checked everything else and isolated the problem to the failure of the PerformClick(). The PerformClick() is in a test subroutine that does nothing but fill textboxes and labels with default data, then calls the PerformClick() on the button to begin processing. Again, the button works fine, the data is entered as it should be, but the PerformClick() does not fire the click event.
I have a form that works on my local Machine I created into. I have Office 2007 on this machine. I created the Form with the Excel 12 Reference. I move the Entire conetence of the Project folder to my work computer. Which has Office 2003. Do I need to recreate the form with the Excel 11 reference. I could not get the form to work on work computer. IT has a com error. I am acessing the EXE for the debug folder w/in the Bin Folder.
View 7 RepliesI have a similar problem posted in the forum similar to this : started learning VB. I am not able to get my example code to work to access an Access database through automation. The author of my book suggested that I might not have the correct Jet 4.0 engine. The specs I have are: MSJet40.dll, Dated 7/14/2009, Prod Ver 4.00.9756.0.
View 3 Replieswill SQL statements that work in Compact SQL Server also work in the Express Edition of SQL Server?
View 2 RepliesDim pc As PrincipalContext = New PrincipalContext(ContextType.Domain, GetPath) ADUserInfo.PasswordVaild = pc.ValidateCredentials(LoginName, Password)
View 1 RepliesI'm using vb2008 with DB MSA2007 (save it to MSA2003) on Seven(7)System After I create my project I build it(make exe). then I took the file of project (application) and the DB from Debug Folder.
I tried to run this application with DB on another computer it's system is seven and MSA2007 and work very well. then I run it on pc it's system XP and MSA2003. it showed this error
Application Error THE APPLICATION FAILED TO INTIALIZE PROPERLY (0XC000135). Click on OK to terminate the application
I'm building a VB(2010) program to create the graphics for my laserprojector.The program works when I debug it in VB, but when I run the EXE program in the release directory, it doesn't work. The problem in the EXE program is theat I can't draw/view graphics in the picturebox..I coppied my whole program to a new VB project, but I'm having the same problem...In the original project, where the program works, there are no warnings or errors.
View 3 RepliesI created a windows form application using Visual Basic Express Edition 2008 but I did not know I could not use it on the web, which is what I wanted but being new to VB I just got a lot of headaches trying to figure this out. It works fine as a windows app but now just recently I installed Visual Web Developer 2005 to so I could create a web application from the windows app.
It is a simple windows application of a datagrid but now I want to run the same design application I made in Visual Basic to Visual Web Developer Express 2005. Is this possible? And, what do I need to do? I have all of the associated files in my project folder in Visual Basic Express folder.
how does look-up work in Visual Basic, I have done research on this but it does not explain. I have a Form1 called( Booking form) with 2 ComboBox's and 1 TextBox. each called (Destination_FromComboBox) and (Destination_ToComboBox) and (FareTextBox)and another form2 called (Fares Form) with 3 TextBox's each called TextBox1 (FromTextBox), TextBox2 (ToTextBox2), TextBox3(FareTextBox).So when I select (Booking Form) and Insert or select a Destination from (Destination_FromComboBox) and Insert or select a Destination To (Destination_ToComboBox) I want to read from (Fare Form/Fare Table) and give me the fare in FareTextBox on the Booking Form. Also on the booking I have 3 Radio Buttons
(RadioButton1 = 4 Seater Car, Normal Fare)
(RadioButton2 = 6 Seater Car, Time & HalfFare)
(RadioButton3 = 8 Seater Car, Double Fare)
But there is also a time Issue as well:
If the time is Between 05:00 & 23:59 then normal time should be used
If the time is Between 00:00 & 02:00 then time & half should be used
If the time is Between 02:00 & 05:00 then Double time should be used
I have watched loads of video's and looked through forums and other codes for the combination of the above, without success?
I have this great way to use VB6 I treated my project like a .exe file.Say I want to work on c:work directory.I just save as the .vbp file to c:work directory
All the other files (.frm,.bas,.cls) files are in a special directory called library ALL of my .vbp files, in c:work1, c:work2, c:work3 refer to that one same directory.How can I do that in vb.net?
Why this is important? Bugs always happen all the time. If I just run .exe file, when bug happen, I cannot do a thing. However, if I run the project file and run the program in debug mode, when bug happen I can figure out what happen.
I am a CS grad, but haven't had much to do with programming since my school days as I went the BA route.Anyways, there are a few things that I do manually on the computer and thought that I could probably save time by creating an application for them.But I'm not really sure how to start.I'd like to be able to keep a history of Completed eBay listing so that I know when the price point is good and when it is too high.I noticed that eBay has an RSS feed, so I think I can do it. Just a couple of quick questions:
1 - Can I instruct VB.net to open a web browser and read an RSS feed, or would I need to manually do this myself and then run the application?
2 - What is the best way to work with RSS feeds? Should I convert the data into XML first?
I am trying to get a percentage that just does not seem to work.I am using WMI to get the Total Physical memory of my system and then the Free Physical Memory. Then get the percentage.
2147483648 - Total Memory
838028 - Free memory
According to Task Manager my physical memory is 59%. This is the code I am using but I can not get 59% or 41% that is free.
temp = FM/TM
temp = temp * 100
percent = FM * temp
I have a simple application:Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
#If DEBUG Then
lblDebug.Text = "Debug"
#Else
lblDebug.Text = "Not in debug"
#End If
Now when I run it in VS, it prints "debug" like it should, but if i run the .exe, it still prints "debug". What do i have to do to get this to work right?