.

January 6, 2009

Get return value in asp.net From SQL server

step1 : create stored procedure
CREATE  PROCEDURE dyntable (@ptable varchar(50),@new_var int  Output )
AS
BEGIN

 Select @new_var=count(*) from admin_master
return @new_var

END
GO
step 2:  Retrive in asp.net
 public void CreatefieldListTable(string strtablename)
    {
        string intconfirm = "";
      
        SqlConnection conn = new SqlConnection(objconn.GetConnection());
        SqlCommand cmdInsert = new SqlCommand("dyntable", conn);
        cmdInsert.CommandType = CommandType.StoredProcedure;
        cmdInsert.Parameters.AddWithValue("@ptable", strtablename);              
        SqlParameter var =new SqlParameter("@new_var",SqlDbType.Int); 
        var.Direction = ParameterDirection.Output;
        cmdInsert.Parameters.Add(var);
        conn.Open();
        SqlDataReader dtread;
        cmdInsert.ExecuteNonQuery();
        string str = Convert.ToString(cmdInsert.Parameters["@new_var"].Value);       
        conn.Close();
    }


No comments: