C# Code For Execute Stored Procedure

AnuLakshmi M

SqlConnection cnn = new SqlConnection();
cnn.ConnectionString = ConfigurationManager.ConnectionStrings["supermarket_webConnectionString"].ConnectionString;

SqlConnection objConnect = cnn;
SqlCommand cmd = new SqlCommand("p_NewpurchaseOrder", objConnect);
cmd.CommandType = CommandType.StoredProcedure;

SqlParameter parXmlPurchaseItems = new SqlParameter("@xml_OrderPurchItems", SqlDbType.VarChar);
parXmlPurchaseItems.Value = XmlPurchaseOrderItems;
cmd.Parameters.Add(parXmlPurchaseItems);

cmd.ExecuteNonQuery();

4 Replies

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

Valarmathi11y ago
how to pass parameter using this
0
Jignesh Trivedi12y ago
Hi,

Are you getting any run time error?

just want to add open the connection before use it.

cnn.Open();
hope this will help you.
0
Nitesh Kejriwal12y ago
Are you getting any error or you want to publish your blog on C# Corner?
0
Ramesh Maruthi12y ago
what error your getting ?

try this code

string ConnectionString = ConfigurationManager.ConnectionStrings["supermarket_webConnectionString"].ConnectionString;

using (SqlConnection con = new SqlConnection(ConnectionString )) {
using (SqlCommand cmd = new SqlCommand("p_NewpurchaseOrder", con)) {
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@xml_OrderPurchItems", SqlDbType.VarChar).Value =XmlPurchaseOrderItems;
con.Open();
cmd.ExecuteNonQuery();
}
}
+1