Inserting data from datagridview to ms access database in c# windows form

Question

hi everyone!!

what i have done that i am uploading an excel file and showing the data in datagridview in windows form .And i want to transfer data from datagridview to ms access database,there is only one row inserting in ms access database at a time.i am inserting the value through textbox help means"gridview to texbox and texbox to ms access",but the problem is that i want to insert multiple rows in ms access database.

Please anyone can help me....I am in a trouble.

Thanks in advance

Regards
mohit verma

Sam Hobbs · Answer

Experienced programmers would put the data into a DataTable in memory and then bind the DataTable to the form for viewing. Then the data could be saved from the DataTable not the form. I do not undertstand what it is that you need to do well enough for me to be more specific. Part of the reason I am not sure what you need to do is that I am not sure what part of what you are saying is something that is being done that you need to change and what part that you need to do that you need help doing. Be careful when saying DataGridView and GridView. A DataGridView is used in Windows Forms applications and a GridView is used in ASP.Net applicaitons. So when you say GridView you are implying that your application is an ASP.Net application.

Satyapriya Nayak · Answer

Hi Mohit Try this... 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 Insert_data_datagridview__access { public partial class Form1 : Form { public OleDbConnection con1; public OleDbConnection con; public void pintu(string s) { con = new OleDbConnection(provider=Microsoft.Jet.OLEDB.4.0;  + data source=' + s +  ';  + Extended Properties=Excel 8.0;); } public OleDbCommand com; public DataSet ds; public OleDbDataAdapter oledbda; public DataTable dt; public string str; public bool ExecuteBatchUpdate(string[] queries) { con1.Open(); OleDbTransaction trans = con1.BeginTransaction(); try { OleDbCommand cmd; foreach (string query in queries) { cmd = new OleDbCommand(query con1 trans); cmd.ExecuteNonQuery(); } trans.Commit(); con1.Close(); return true; } catch (Exception) { trans.Rollback(); con1.Close(); return false; } } public Form1() { InitializeComponent(); string databaseName = d:\emp.mdb; string ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + databaseName; con1 = new OleDbConnection(ConnectionString); } private void btnbrowse_Click(object sender EventArgs e) { OpenFileDialog openfiledialog1 = new OpenFileDialog(); openfiledialog1.ShowDialog(); openfiledialog1.Filter = allfiles|*.xls; TextBox1.Text = openfiledialog1.FileName; } private void btndisplay_Click(object sender EventArgs e) { pintu(TextBox1.Text); try { con.Open(); str = select * from [sheet1$]; com = new OleDbCommand(str con); ds = new DataSet(); oledbda = new OleDbDataAdapter(com); oledbda.Fill(ds [sheet1$]); con.Close(); DataGridView1.DataSource = ds; DataGridView1.DataMember = [sheet1$]; } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void btn_insert_Click(object sender EventArgs e) { List queries = new List (); foreach (DataGridViewRow row in DataGridView1.Rows) { if (!row.IsNewRow) { queries.Add(Insert Into employee (empidempnamesal) values (' + row.Cells[0].Value.ToString() + '' + row.Cells[1].Value.ToString() + '' + row.Cells[2].Value.ToString() + ')); } } if (ExecuteBatchUpdate(queries.ToArray())) { MessageBox.Show(Records Inserted Successful); } else { MessageBox.Show(Inserted Failed!); } } } } Thanks If this post helps you mark it as answer