bind a datatable to datagridview and save to other table

Question

hello guys i bound a datatable to datagridview. Lateri add a column to that dgv then want to save dgv recods to other table. Please note that i want to save datagridview records to different table. Thanks in advance.

Satyapriya Nayak · Answer

Form1.cs using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Insertdata_from_datagrid__dbcsharp { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; OleDbCommand com; OleDbDataAdapter oledbda; DataSet ds; string str; public Form1() { InitializeComponent(); } private void btn_insert_Click(object sender EventArgs e) { for (int i = 0; i { str = @INSERT INTO student1(sidsnamesmarkssaddress) VALUES (' + dataGridView1.Rows[i].Cells[sid].Value + ' ' + dataGridView1.Rows[i].Cells[sname].Value + ' + dataGridView1.Rows[i].Cells[smarks].Value + ' + dataGridView1.Rows[i].Cells[saddress].Value + ');; try { using (OleDbConnection con = new OleDbConnection(ConnectionString)) { using (com = new OleDbCommand(str con)) { con.Open(); com.ExecuteNonQuery(); } } } catch (Exception ex) { MessageBox.Show(ex.Message Error MessageBoxButtons.OK MessageBoxIcon.Error); } } label1.Text = Records inserted successfully; } private void bindgrid() { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from student; com = new OleDbCommand(str con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds student); dataGridView1.DataMember = student; dataGridView1.DataSource = ds; con.Close(); } private void Form1_Load(object sender EventArgs e) { bindgrid(); } } }

Rakesh Kaushik · Answer

Lot of Thanks Sir.