how to transfer data from datagridview to sql server table ?

Question

how to transfer data from datagridview rows to sql server table ?!!!

Satyapriya Nayak · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Insert datagridview records to database. App.config xml version = " 1.0 " encoding = " utf-8 " ?> configuration > appSettings > add key = " dsn " value = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\EMP.mdb " /> appSettings > configuration > 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(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(); } } } Thanks If this post helps you mark it as answer /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;}

how to transfer data from datagridview to sql server table ?

Answers (1)