Want to know all things that are doing in data gridview?

Hello Friend,
Kindly go through the following link.

http://www.c-sharpcorner.com/uploadfile/17e8f6/how-to-pass-values-from-a-datagridview-to-form-through-ado-net/

For working with procedures for insert, update or delete. it's quite simple

con = new SqlConnection("Data Source=D-NIIT-CR02;Initial Catalog=AdventureWorks;User Id=XXX;Password=XXX");

con.Open();

cmd = new SqlCommand("procedureName", con);
cmd.CommandType=CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@enqid", enqid);

cmd.Parameters.AddWithValue("@name", stdname);

cmd.Parameters.AddWithValue("@add", stdadd);

cmd.Parameters.AddWithValue("@quali", stdqualification);

cmd.Parameters.AddWithValue("@course", stdcourse);

int rows = cmd.ExecuteNonQuery();

if (rows > 0)

{

MessageBox.Show("Inserted Successfully");

}

else

{

MessageBox.Show("Error Inserting data");

}

Hope that solves your problem.

With Regards,
Vishal Gilbile

1 Reply

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

Vishal Gilbile13y ago
Hello Friend,
Kindly go through the following link.

http://www.c-sharpcorner.com/uploadfile/17e8f6/how-to-pass-values-from-a-datagridview-to-form-through-ado-net/

For working with procedures for insert, update or delete. it's quite simple

con = new SqlConnection("Data Source=D-NIIT-CR02;Initial Catalog=AdventureWorks;User Id=XXX;Password=XXX");
con.Open();
cmd = new SqlCommand("procedureName", con);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@enqid", enqid);
cmd.Parameters.AddWithValue("@name", stdname);
cmd.Parameters.AddWithValue("@add", stdadd);
cmd.Parameters.AddWithValue("@quali", stdqualification);
cmd.Parameters.AddWithValue("@course", stdcourse);
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Inserted Successfully");
}
else
{
MessageBox.Show("Error Inserting data");
}

Hope that solves your problem.

With Regards,
Vishal Gilbile