How to get result from two table in SqlDataReader

string str="Select * from table1;Select * from table2"; cmd.commandtext=str; dr=cmd.executereader();