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:
Post a Comment