creating stored procedure in sql server

Rinku Dhadse

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Patel10y ago
Accepted 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 Singh10y ago
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 Patel10y ago
Hi ,
check this

http://www.codeproject.com/Articles/17667/Insert-and-retrieve-data-through-stored-procedure
Amit Kumar Singh10y ago
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/