When is use the connection.open() and connection.close()
After about 100 times, errors come up:
Any idea what causes this or how can I work around it?
So basically, if someone updates around 100 records this way, the program crashes. This also happens if I had to read 100...
Ive spent many days just googling source code ad help. But nothing seems to work. Im using .net 1.1 with vb.net 2003
This is the error I get when updating the database:
Additional information: No error information available: E_FAIL(0x80004005).
Actualy the source code is taken from another...
I have been searching and reading many examples of how to do this.
Best method I found was,
But this does not go to the database, if I close the app and open it again, the updated information is not in the database.
Im using a mysql database and I have to code...
Thanks. Though I get an error:
Value cannot be null.
Parameter name: dataTable
So I used some other code:
This works fine, most of the declarations are done in the class.
How would I now update any information that I change in the text box to update into the database?
This is what im using so far, ive only gone as far as reading from the database, not storing/updating.
Dim temp As Integer
temp = id.SelectedItem
Dim fdCom1 As New OleDb.OleDbCommand("SELECT * FROM client where clientid =" & temp, fdCon)
Dim fdRead1 As...
Im using a combobox to view the the primary key from a mysql database.
Upon combox selected index change, the text boxes get the new info for that specific primary key.
My problem is, when I scroll the combobox with the keyboard, by just holding down the down or up arrow keys, after I scroll...
Can anyone help me with using a combobox and textbox for showing data from a mysql database.
I mostly found examples using the datagrid and cannont find any help on using textboxes.
Please assist. I am using myodbc or you recommend another connecter?