Estimado compañero espero que esto te ayude:
Código ASP:
Ver originalpublic static DataTable GetData()
{
SqlConnection myconn;
myconn=new SqlConnection();
DataTable Mydata;
Mydata = new DataTable();
myconn.ConnectionString = "Data Source=HMORI\\HUMBERTO3;Initial Catalog=csharp;Integrated Security=True";
SqlCommand mycommand;
mycommand = new SqlCommand();
mycommand.CommandType = CommandType.StoredProcedure;
mycommand.CommandText="sp_codcli";
mycommand.Connection = myconn;
try
{
mycommand.Parameters.Add("@parametro01", SqlDbType.Int).Value = 6;
mycommand.ExecuteNonQuery();
}
catch (Exception error)
{
throw new Exception();
}
finally
{
myconn.Open();
}
return Mydata;
}