updating an SQL table in C#
-
Hi I'm using some DevExpress components in C#. Using sqlConnection, sqlDataAdapter, dataSet, gridControl (a Datagrid) and controlNavigator (to choose insert record, edit record etc.). When I make my program I can see all the data in the table. Using the controlNavigator I can add records, delete them etc. I use Microsoft SQL server 2000. I understand that my program loads a local copy of the database and at the end I have to let the program know that the real table now needs to be updated. I made a button under which I can test some commands. I tried sqlDataAdapter1.Update(dataset11) and sqlDataAdapter1.Update(DataSet11,"films") (where films is the name of the table) also I tried dataSet11.acceptchanges(). No matter what I try each time when I quit the program and restart the program my table is empty. What do I need to do to effectivly change/update the real table?? I would like a solution where I can input/change data in the datagrid using the controlNavigator and then by adding somewhere some extra code make the changes permanent. I hope someone can help Kind regards, Clem