update database using dataGridView, where dataTables are added dynamically

Nov 19 2009 12:53 PM

Could you, please, help me to solve this:


dAdapter.Update(dTable);

when my dTable depends on user choice. I have one Dataset with several tables, and name of the chosen Table apears in Label1.Text.

How to save changes from dataGridView to Database? The problem is that bindigSource.DataMember is known only in runtime, when user select the Table Name.

I have tried following code:


  private void saveToolStripButton_Click(object sender, EventArgs e)
{

OleDbDataAdapter da = new OleDbDataAdapter();
BindingSource bindingSource1 = new BindingSource();

bindingSource1.DataMember = label1.Text;


bindingSource1.DataSource = dataGridView1.DataSource;

this.Validate();
this.bindingSource1.DataSource = ds;
this.bindingSource1.DataMember = label1.Text;
DataTable dt = bindingSource1.DataSource as DataTable;

this.bindingSource1.EndEdit();

if (dt != null)
{
this.tableAdapterManager.UpdateAll(ds);
}
}



Answers (2)