Save from DataGridView c# to database

Question

Is there tutorils videos about this thing ?

Satyapriya Nayak · Answer

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(sid,sname,smarks,saddress) 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(); } } }

Satyapriya Nayak · Answer

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 Update_delete_datagridview { public partial class Form1 : Form { OleDbDataAdapter oledbda; OleDbCommandBuilder olcb; DataTable dataTable; BindingSource bindingSource; string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "SELECT * FROM student"; oledbda = new OleDbDataAdapter(str, con); olcb = new OleDbCommandBuilder(oledbda); dataTable = new DataTable(); oledbda.Fill(dataTable); con.Close(); bindingSource = new BindingSource(); bindingSource.DataSource = dataTable; dataGridView1.DataSource = bindingSource; dataGridView1.Columns[0].Visible = false; } private void btnaddupdate_Click(object sender, EventArgs e) { try { oledbda.Update(dataTable); } catch (Exception exceptionObj) { MessageBox.Show(exceptionObj.Message.ToString()); } MessageBox.Show("Records updated"); } private void btndelete_Click(object sender, EventArgs e) { try { dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index); oledbda.Update(dataTable); } catch (Exception exceptionObj) { MessageBox.Show(exceptionObj.Message.ToString()); } MessageBox.Show("Records Deleted"); } } }

reyadh khalifeh · Answer

Thank you very much , can you tell me how can I see all records that I save it .

reyadh khalifeh · Answer

Tank you my dear ,but after I fill the cells how can I save it ? and after I save it how can I see it ?

Save from DataGridView c# to database

Answers (4)