I'm having a problem getting the .update method in vb.net to work. I'm using MySQL as the database and have got a data bound datagrid bound via a dataset, data adapter and connection. I can view no problem but any updates, deletes or inserts are just ignored. When I use the dAdapter wizard to create the SQL texts it does come up with an error saying it could not create the update or delete command strings so I have made my own. Nothing happens..! Very frustrating. Also the datagrid keeps picking up a redundant column in the table I'm accessing - I changed the name a while ago and despite deleting the dataset it still finds the old name and has an extra column. Ideas???
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).