stored procedure using c#?

[nirmalsingh]

hai all,
i am new to asp.net. by using vs 2005 i want to write a stored procedure to save and retrieve data from database. kindly guide me to do this.
thanx in advance.

[ghousebarq]

hai all,
i am new to asp.net. by using vs 2005 i want to write a stored procedure to save and retrieve data from database. kindly guide me to do this.
thanx in advance.

Hi,
The below link should help you.

http://msdn2.microsoft.com/en-us/library/d7125bke(VS.80).aspx

[Shivam Varshi]

hai all,
i am new to asp.net. by using vs 2005 i want to write a stored procedure to save and retrieve data from database. kindly guide me to do this.
thanx in advance.

Dear,
you can use this codes for your queries..

public class ExecuteSQLComma nd
{
string strCommandName;
SqlCommand objCommand;
SqlParameter objParam;
//Set the Connection String to the Database
SqlConnection objConnection = new SqlConnection(" server=localhos t;uid=sa;pwd=;I nitial Catalog=Home");
try
{
//Name of the Stored Procedure to be executed
strCommandName = "spStoredProced ureName";
objCommand = new SqlCommand(strC ommandName, objConnection);
objCommand.Comm andType = CommandType.Sto redProcedure;
//Set the Parameters
objParam = objCommand.Para meters.Add(new SqlParameter("@ VariableOne", SqlDbType.VarCh ar, 50));
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = strVariableOne;
objParam = objCommand.Para meters.Add(new SqlParameter("@ VariableTwo", SqlDbType.Int)) ;
objParam.Direct ion = ParameterDirect ion.Output;
objCommand.Conn ection.Open();
objCommand.Exec uteNonQuery();
//'Get the Out parameter from the Stored Procedure
intValueReturn = Convert.ToInt32 ((objCommand.Pa rameters["@getValueVaria bleName"].Value.ToString ()));

}

catch(Exception ex)
{
throw ex;
}

finally
{
if ( objConnection.S tate == ConnectionState .Open) objConnection.C lose(); objReader.Close ();
}



}

[dhanashivam]

hi

did u get any reply for it?

regards,
dhanasekaran.g