VB is not updating SQL

[jimmyavr]

Hi,

 

I wonder if anyone can guide me on this.

 

I'm currently working on a project which requires me to use databases from our SQL server. I have created a dataset and attached it to a form, visual studio is connected to the relevant database within SQL also (this was the easy bit). Now when I run the application, it populates the dataset and shows me the correct information in the table view that I was after. Yet when I make any changes within the form it does not make the same changes in the database.

 

So basically, the form is filling and getting the relevant data from SQL but not updating back to it.

 

I hope this is easy to understand, i'm relatively new to SQL and VB.

 

Am i missing something really simply? Or is this more complex then a few clicks within Visual Studio?

[Grazza]

Hi I think you have to update the database from the record set.

 

I'm not to sure as I do all my VB/SQL programmatically, I never use bound controls, I don't like them, which might be why my application is over 23,000 lines !

 

Regards

 

Graham