Hi Iratus7,
Since you are pointing to same database, you can use combine two query into single query and fetch it and bind it to the datasource.
It will be easy for you.
Like
select B1.blah1,B2.blah2 from blah1 B1,blah2 B2
Use the below code instead of yours
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BasketballConnectionString1"].ToString());
string query;
SqlCommand SqlCommand;
SqlDataReader reader;
SqlDataAdapter adapter = new SqlDataAdapter();
conn.Open();
query = "select B1.blah1,B2.blah2 from blah1 B1,blah2 B2";
SqlCommand = new SqlCommand(query, conn);
adapter.SelectCommand = new SqlCommand(query, conn);
reader = SqlCommand.ExecuteReader();
GridView4.DataSource = reader;
GridView4.DataBind();
conn.Close();
}
Hope this would help you a bit.
Regards,
RK