I have a stored procedure with two select statments. I'm trying to bind data from both selects in one list view.
Do I need to specifically call the two datasets in my .Net code?
Currently my .Net code looks like this:
try
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("usp_GetDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mkey", Request.QueryString["mkey"]);
con.Open();
SqlDataReader reader;
reader = cmd.ExecuteReader();
List.DataSource = reader;
List.DataBind();
}
TI'm receiving a databinding error that is telling me that the data from the second select statment in the stored procedure does not e ...
Go to the complete details ...