Updating changings back to DB from DataGridView

[WinSolution]

Dear All I want to updated the changes made in DataGridView back to SQL Table in an easiest way while i am working with 3-Tire approach (GUI, BusinessLogic, DataAccess) I have search a lot on Google but i am not able to find a good,simple and easy solution. Thanks for helping.

[Henry Minute]

Try looking at this[^], it might help.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[Lost User]

Hi , if you want to save datagrid back to SQL database then there is a very simple rules : - every table must have PK ( Exception will rise if don't )

        ds = new DataSet("tb");
        
        clsConnect.SqlDa = new SqlDataAdapter("SELECT \* FROM tb1 WHERE ID = 2", clsConnect.SqlCon);

        clsConnect.SqlCmdBuild = new SqlCommandBuilder(clsConnect.SqlDa);
        
        clsConnect.SqlDa.InsertCommand = clsConnect.SqlCmdBuild.GetInsertCommand();
        clsConnect.SqlDa.DeleteCommand = clsConnect.SqlCmdBuild.GetDeleteCommand();
        clsConnect.SqlDa.UpdateCommand = clsConnect.SqlCmdBuild.GetUpdateCommand();

        clsConnect.SqlDa.Fill(ds , "tb");
        dataGridView1.DataSource = ds.Tables\[0\];
        clsConnect.SqlDa.Update(ds.Tables\[0\]);
        ds.Tables\[0\].AcceptChanges();

I know nothing , I know nothing ...

[Henry Minute]

Hi Stark DaFixzer, Just posting to say I like the image in your user profile. Cute!

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[Lost User]

Thank you , this picture is "Baby Tux" .. linux stuff here is a big one , you can have it ... Click Here please

I know nothing , I know nothing ...

[WinSolution]

Thanks But i need an example that is based on 3-Tire Architecture.(GUI, BusinessLogic, DataAccess) i have tried such code with 3-Tire Arch. but it cause an error like "DataTable already belongs to another DataSet".

[Lost User]

I am sorry this beyond my knowledge ... :( forgive me ... :rose:

I know nothing , I know nothing ...