textBox1.Text = "insert"; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.CommandText = "prcfunddetails"; cmd.Parameters.Add("@action", SqlDbType.VarChar); cmd.Parameters.Add("@fundid", SqlDbType.Int); cmd.Parameters.Add("@name", SqlDbType.VarChar); cmd.Parameters.Add("@startdate", SqlDbType.DateTime); cmd.Parameters.Add("@enddate", SqlDbType.DateTime); for (int i = 0; i<dataGridView1.Rows.Count; i++) { cmd.Parameters["@action"].Value = textBox1.Text; cmd.Parameters["@fundid"].Value = dataGridView1.Rows[i].Cells[0].Value; cmd.Parameters["@name"].Value = dataGridView1.Rows[i].Cells[1].Value; cmd.Parameters["@startdate"].Value = dataGridView1.Rows[i].Cells[2].Value; cmd.Parameters["@enddate"].Value = dataGridView1.Rows[i].Cells[3].Value; cmd.ExecuteNonQuery(); } MessageBox.Show("Records successfully inserted");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)