stored proedure in c#
hi sir... i wana sample stored procedure example can u please snd me create a stored procedure in sqlserver and using c# we can update it this is the question please sit i want to know the concept of stored procedure... actually i am learning dotnet self so please help me
Anurag SarkarPosted Jul 30, 2013, 4:30 AM
You can use them in C# using SqlCommanad Class.
Example:-
cmd=new SqlCommand("storeprocname",con); cmd.commandtype=CommandType.StoredProcedure;
cmd.executeNonQuery;
Thanks.
Sunny SharmaPosted Jul 30, 2013, 3:56 AM
Follow this post:http://support.microsoft.com/kb/320916
It has all the example and explanations that you need to know.
Happy Coding :)
Cheers!
Sanjeeb LenkaPosted Jul 30, 2013, 3:51 AM
CREATE PROCEDURE usp_SelectRecord
AS
BEGIN
SELECT *
FROM TABLE
END
GO
EXEC usp_SelectRecord
you can check this link for insert stored procedure in C# example
http://www.c-sharpcorner.com/uploadfile/jitendra1987/sql-server-stored-procedure-with-C-Sharp-net/