40% Get Big Discount For a Limited time
sandeep
@sandeep
For calling stored procedure from sql server this method can be used: SqlCommand cmd = new SqlCommand("[Usp_Save]", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = txtTitle.Text.Trim(); cmd.Parameters.Add("@Descr", SqlDbType.NVarChar).Value = txtDesc.Text; con.Open(); cmd.ExecuteNonQuery(); con.Close();
SqlCommand cmd = new SqlCommand("[Usp_Save]", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = txtTitle.Text.Trim(); cmd.Parameters.Add("@Descr", SqlDbType.NVarChar).Value = txtDesc.Text; con.Open(); cmd.ExecuteNonQuery(); con.Close();
Get the updates, offers, tips and enhance your page building experience
Answers
For calling stored procedure from sql server this method can be used:
SqlCommand cmd = new SqlCommand("[Usp_Save]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = txtTitle.Text.Trim();
cmd.Parameters.Add("@Descr", SqlDbType.NVarChar).Value = txtDesc.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
@pallav
March 04,2016 At 02:13 PM
Solution #1