Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forumguidelines
AnuLakshmi M
2k
12
2.6k
C# Code For Execute Stored Procedure
Sep 10 2014 10:05 AM
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();
Reply
Answers (
4
)
Datatable to XML in C#
How to Array using table column value passing array