protected void Table3_Click(object sender, EventArgs e) { //Retrieves the next record set dataReader.NextResult(); GridViewRecordSet1.DataSource = dataReader; GridViewRecordSet1.DataBind(); }
protected void Table1_Click(object sender, EventArgs e) { var con = new SqlConnection(connectionString); var command = new SqlCommand("MultiRecordSet", con); command.CommandType = CommandType.StoredProcedure; con.Open(); dataReader = command.ExecuteReader(); //Retrieves the First record set GridViewRecordSet1.DataSource = dataReader; GridViewRecordSet1.DataBind(); }