private void button3_Click(object sender, EventArgs e) { try { cmd.Parameters.Clear(); cmd.CommandText = "Ins_Upd_Students";//Ins_Upd_Students is my stored procedure cmd.Parameters.AddWithValue("@Sno", textBox1.Text); cmd.Parameters.AddWithValue("@Sname", textBox2.Text); cmd.Parameters.AddWithValue("@Class", textBox3.Text); cmd.Parameters.AddWithValue("@Fees", textBox4.Text); con.Open(); int affectedRecord=cmd.ExecuteNonQuery(); MessageBox.Show("Executed"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } }
cmd.Parameters.AddWithValue("@Sno", Convert.ToInt32(textBox1.Text));
cmd.Parameters.Add("@Sno", SqlDbType.Int); cmd.Parameters("@Sno").Value = sno;
INT
Stored Procedure
varchar
AddWithValue("@Sno", textBox1.Text);
AddWithValue("@Sno", int.Parse(textBox1.Text));
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)