Datagridview

Question

hi ALL

I am trying to insert data from datagridview to sql, but i only insert one line or one row,
below is the code i am using.

int row = dataGridView1.Rows.Count-2;

SqlConnection conn = new SqlConnection("Data Source=KATOTO-PC;Initial Catalog =thyfarm;User ID=sa;Password=Kyozi");

conn.Open();

string insertString = "insert into Treatmentpurchases (day) values ('" + dataGridView1.Rows[row].Cells["Day"].Value + "')";
SqlCommand cmd = new SqlCommand(insertString, conn);

cmd.ExecuteNonQuery();
conn.Close();

any help will be highly appreciated.

Aaron Colen · Answer

Lets break it down and go from there. The first line sets 'row' to the number of rows in your datagrid minus 2. int row = dataGridView1.Rows.Count-2; Further down your insert string uses the 'row' to get the value of one row from the datagridview. string insertString = insert into Treatmentpurchases (day) values (' + dataGridView1.Rows[row].Cells[ Day ].Value + ') ; If you are trying to insert all rows on the datagridview you would need to loop through it. For example: foreach( DataGridViewRow row in dataGridView1.Rows) { string insertString = insert into Treatmentpurchases (day) values (' + row.Cells[ Day ].Value + ') ; SqlCommand cmd = new SqlCommand (insertString conn); cmd.ExecuteNonQuery(); } You will of course need to modify the above to run properly but it should give you an idea of what went wrong.