DataGridView the current row insert into Access database?

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");

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.