DataGridView the current row insert into Access database?

Question

hi friends How to make the DataGridView the current row with new values to the ACCESS database ? i want to insert into Access database! thanks! br/fei

Biswa Pujarini Mohapatra · Answer

here is your sample code please modify as per your requirement foreach(DataGridViewRow row in DataGridView1.SelectedRows) { string id = row.Cells[id].Value.ToString(); string name = row.cells[Name].Value.ToString(); OleDbCommand cmd = new OleDbCommand(INSERT into Login (id Name) Values(@id @Name)); cmd.Connection = conn; conn.Open(); if (conn.State == ConnectionState.Open) { cmd.Parameters.Add(@id OleDbType.VarChar).Value = id; cmd.Parameters.Add(@Name OleDbType.VarChar).Value = name; try { cmd.ExecuteNonQuery(); MessageBox.Show(Data Added); conn.Close(); } catch (OleDbException ex) { MessageBox.Show(ex.Source); conn.Close(); } } else { MessageBox.Show(Connection Failed); } }