executing Stroed procedures using .net

[cvraghavan1979]

Hi guys! can any one help me to know how we can execute stored procedures of SQL server in .net

[mathewgk80]

Hi guys! can any one help me to know how we can execute stored procedures of SQL server in .net

Hi,

 sqlConRowUpdate = new SqlConnection(strConnectionString);
            sqlConRowUpdate.Open();
            SqlCommand SqlCmdRowUpdate = new SqlCommand();
            SqlCmdRowUpdate.Connection = sqlConRowUpdate;
            SqlCmdRowUpdate.CommandText = "procUpdatePDetails";
            SqlCmdRowUpdate.CommandType = CommandType.StoredProcedure;
            SqlCmdRowUpdate.Parameters.Add("@purchaseid", SqlDbType.VarChar).Value = strPurchaseId;
            SqlCmdRowUpdate.Parameters.Add("@productname", SqlDbType.VarChar).Value = strProductNameNew;
            SqlCmdRowUpdate.Parameters.Add("@noofitems", SqlDbType.Int).Value = intNoOfItems;
            SqlCmdRowUpdate.Parameters.Add("@priceperunit", SqlDbType.Int).Value = intPricePerUnit;
            SqlCmdRowUpdate.ExecuteNonQuery();
 

The above is an example of executing stored procedure in .net. In the above code,"procUpdatePDetails" is the stored procedure.

Regards,

Mathew.

[cvraghavan1979]

hi,

thank u mathew. i got an idea of using the stored procedures through the example given by you. thank u for ur timely help. looking forward for a good team work with u and other team members. Have A Nice Day!

regards,
vijay