2 Sql Select Statements In 1 Sql String Just Wont Work!

hi there, i have a bit of a strange problem, and i must be doing something wrong because this works with insert and update statements in other pages. What is going on is that i am trying to do 2 select statements in the same bit of code so i dont have to open a datareader twice, but if i put the delivery charge select before the other it seems to get it, but if i put it after it does not, i just cant work it out! i have posted my code below for you all to have a look at because im stumped!

//gets order id and customer id and puts them to strings and int to be used laterstring strCustID = Request.QueryString["qsnOrderCustID"].ToString();

int intCustID = Convert.ToInt32(strCustID);string strOrderID = Request.QueryString["orderID"].ToString();int intOrderID = Convert.ToInt32(strOrderID);

 

//This is the sql statement.string sql = "SELECT [sub_total], [VAT], [Total] FROM tbl_order WHERE order_ID = " + intOrderID + ";" + "SELECT [del_cost] FROM tbl_del WHERE order_ID = " + intOrderID;

 

//This creates a sql command which executes the sql statement.SqlCommand sqlCmd = new SqlCommand(sql, myConn);

myConn.Open();SqlDataReader dr = sqlCmd.ExecuteReader();

 

//This reads the first result from the sqlReader

dr.Read();

//This sets the title label text to the value of the description column.

try

{

 

//fill these labels with the first select statement lblSubTot.Text = dr["sub_total"].ToString();

lblVAT.Text = dr["VAT"].ToString();lblOrderTotal.Text = dr["Total"].ToString();lblDelCharge.Text = dr["del_cost"].ToString();

 

//fill this label with the second select statementlblDelCharge.Text = dr["del_cost"].ToString();

}catch (Exception except)

{string strError = Convert.ToString(except);

}

finally

{

myConn.Close();

}

any ideas would be great! thanks

Jez