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