Loading

DataGridView Date save

DataGridView Date save

Zeb Muhammad

Zeb Muhammad

9y787Learn iOS Programming

Dear Friends,

I want to save Date from DataGridView to Database.

my Date Datatype is DateTime in DB.

please, check my code

private void button4_Click(object sender, EventArgs e)

{

con.Open();

for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)

{

SqlCommand cmd = new SqlCommand("INSERT INTO cat1_tab (myDate) VALUES(@myDate)", con);

cmd.Parameters.Add("@mydate",dataGridView1.Rows[i].Cells[7].Value.ToString("yyyy-MM-dd"));

cmd.ExecuteNonQuery();

MessageBox.Show("save");

con.Close();

}

}

Thx

2 Replies

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

Zeb Muhammad9y ago
Thx Amit for responding
please, check again my code i got Exception error
private void button4_Click(object sender, EventArgs e)
      {

          for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
          {

              con.Open();
              SqlCommand cmd = new SqlCommand("INSERT INTO cat1_tab (myDate) VALUES(@myDate)", con);
              cmd.Parameters.Add("@mydate",dataGridView1.Rows[i].Cells[7].Value);
              cmd.ExecuteNonQuery();
              con.Close();
          }
          MessageBox.Show("save");
      }
Amit Gupta9y ago
I think, it might caught exception, as you had closed your connection and also wrtite your message box outside the loop

Edited:
private void button4_Click(object sender, EventArgs e)
{
con.Open();
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
SqlCommand cmd = new SqlCommand("INSERT INTO cat1_tab (myDate) VALUES(@myDate)", con);
cmd.Parameters.AddWithValue("@mydate",Convert.ToDateTime(dataGridView1.Rows[i].Cells[7].Value).ToString("yyyy-MM-dd"));
cmd.ExecuteNonQuery();
}
MessageBox.Show("save");
con.Close();

}