How to use Stored Procedure in ASP.net using C# with Sql Server 2005

Have a look here:
How to create a SQL Server stored procedure with parameters[^]
Using Stored Procedures with a Command[^]
How to: Execute a Parameterized Stored Procedure Using EntityCommand[^]
http://support.microsoft.com/kb/310070[^]

Is it enough for start?

Hi,

you can try some thing like this

create procedure insert_data
(
    @Id int, @Name Varchar(20) , @address varchar(50)
)
begin

Insert into table1(Id,Name,address) values(@Id,@Name,@address)

end

you can use the following c# code on button click to insert data

try
  {
     sqlConnection  con = new SqlConnection(dbConnectionString);
     SqlCommand comm= new SqlCommand("insert_data", con);
     comm.CommandType = CommandType.StoredProcedure;
     comm.Parameters.Add("@Id", SqlDbType.VarChar).Value = txtId.Text;
     comm.Parameters.Add("@Name", SqlDbType.DateTime).Value = txtName.Text;
     comm.Parameters.Add("@Address", SqlDbType.DateTime).Value = txtaddress.Text;
     sqlConnection.Open();
     return comm.ExecuteNonQuery();
     sqlConnection.Close();
  }
catch (SqlException ex)
  {
     Console.WriteLine("SQL Error" + ex.Message.ToString());
     return 0;
  }

I hope it will help you..

You can try this-

SqlCommand command = new SqlCommand("dbo.sp_name", (SqlConnection)session.Connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@param_name1", "Param Value 1"));
command.Parameters.Add(new SqlParameter("@param_name2", "Param Value 1"));
command.ExecuteNonQuery();

Thanks.

//this is write in your button event
static SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DbCon"].ConnectionString);

con.open();
SqlCommand cmd = new con.createcommand;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@paramName1", "Param Value 1"));
cmd.Parameters.Add(new SqlParameter("@paramName2", "Param Value 1"));
cmd.ExecuteNonQuery();
con.close();

//create store procedure
CREATE PROCEDURE [dbo].[ProcedureName]
@paramName1 int = 0,
@paramName2 int
AS
SELECT @paramName1, @paramName2
RETURN 0

hope it useful to you...

Go through this link, this should be helpful for you
Asp.net GridView Crud Operations (Insert Select Edit Update Delete) using Single Stored Procedure Example

string constr=@"Data Source=Server Name;Initial Catalog=Db name;Integrated Security=true;
SqlConnection con= new SqlConnection(constr);
SqlCommand com = new SqlCommand("StoredProcedureName,constr")
SqlCommandType = commandType.StoredProcedure;
con.Open();
com.Parameters.AddWithValue(@Param,Value);
com.Parameters.AddWithValue(@Param,Value);
com.Parameters.AddWithValue(@Param,Value);
com.ExecuteNonQuary();
con.Close();