SQL Commands Not Working

[Guest]

As I am using a datagridview based on a view in my SQL database. The default
update() command isnt created and hence, I am currently using insert and
update commands thru the dataset wizard.

However, none of the insert or update SQL commands seem to work for me. No
errors are provided but yet nothing is inserted into the database. Does
anyone knows how to solve this?

 

[Nicholas Paldino [.NET/C# MVP]]

Airkon,

Are you making calls to the data adapter which is generated for you,
passing the data source of the grid? Also, are you sure you are making
changes to the grid which is updating the underlying data source (the row
state of the data table has to be changed in order for the data adapter to
be aware that something should be updated).