creating stored procedure in sql server

Question

hello Sir, I am Rinku Dhadse developing web Application in which i want to create Stored procedure in Sql Server and call it in my C# code how i write code and how i use it in asp.net.

Ravi Patel · Answer

Hi, try this way //stored procedure create procedure sp_Insert @Id int, @Name varchar(50) as begin Insert into table1(Id, FullName) values(@Id,@Name) end c# code try { sqlConnection = new SqlConnection(dbConnectionString); SqlCommand command = new SqlCommand("sp_Insert", sqlConnection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@Id", SqlDbType.VarChar).Value = txtId.Text; command.Parameters.Add("@Name", SqlDbType.DateTime).Value = txtName.Text; sqlConnection.Open(); return command.ExecuteNonQuery(); sqlConnection.Close(); } catch (SqlException ex) { Console.WriteLine("SQL Error" + ex.Message.ToString()); return 0; }

Krishna Rajput Singh · Answer

Hello Rinku Dhadse thanks for writing below links i hope helpful for you...:) https://msdn.microsoft.com/en-IN/library/ms345415.aspx https://www.mssqltips.com/sqlservertutorial/162/how-to-create-a-sql-server-stored-procedure-with-parameters/ http://www.c-sharpcorner.com/UploadFile/37db1d/creating-and-managing-stored-procedure-in-sql-server-2008/ http://stackoverflow.com/questions/19947878/sql-server-how-to-create-a-stored-procedure if find helpful answer mark as correct

Ravi Patel · Answer

Hi , check this http://www.codeproject.com/Articles/17667/Insert-and-retrieve-data-through-stored-procedure

Amit Singh · Answer

1.http://www.aspsnippets.com/Articles/Calling-Insert-SQL-Server-Stored-Procedures-using-ADO.Net.aspx 2.http://codedada.com/how-to-create-insert-delete-and-update-using-stored-procedure-in-asp-net/

creating stored procedure in sql server

Answers (4)