stored proedure in c#

Question

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 Sarkar · Answer

Stored Procedure is a part of Sql. You can use them in C# using SqlCommanad Class. Example:- cmd=new SqlCommand(storeprocnamecon); cmd.commandtype=CommandType.StoredProcedure; cmd.executeNonQuery; Thanks.

Sunny Sharma · Answer

Hi Satish Follow this post: http://support.microsoft.com/kb/320916 I t has all the example and explanations that you need to know. Happy Coding :) Cheers!

Sanjeeb Lenka · Answer

hi you can try this 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/