Search results

  1. D

    too many connections

    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? source code So basically, if someone updates around 100 records this way, the program crashes. This also happens if I had to read 100...
  2. D

    Database update - please help

    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...
  3. D

    updating database

    I donot see any database listing in the solution explorer, just the form1.vb, assemblyinfo.vb and the references.
  4. D

    updating database

    I have been searching and reading many examples of how to do this. Best method I found was, mydataadapter.update(dataset) 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...
  5. D

    Combobox and Textbox data binding

    Thanks jmcilhinney. This is a fun new way to display data.:cool: :D Your time, code and patience is greatly appreciated. Regards Nolan www.digitalquark.com
  6. D

    Combobox and Textbox data binding

    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? Thanks
  7. D

    Combobox and Textbox data binding

    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) fdCom1.Connection.Open() Try Dim fdRead1 As...
  8. D

    Combobox and Textbox data binding

    Im trying to make a front end for a mysql database but I dont want to use a datagrid. I want to to individual controls(textboxes) for each colum in the table.
  9. D

    too many connections on update?

    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...
  10. D

    Combobox and Textbox data binding

    Hi 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? Regards Nolan
Top Bottom