Try following-
using (SqlDataReader msqldat = msqlcmd.ExecuteReader())
{
msqldat.Read();
}
msqlcmd.CommandText = "select * from table2";
using (SqlDataReader msqldat = msqlcmd.ExecuteReader())
{
msqldat = msqlcmd.ExecuteReader();
while (msqldat.Read())
{
}
}
msqlcmd.CommandText = "select * from table3";
using (SqlDataReader msqldat = msqlcmd.ExecuteReader())
{
msqldat = msqlcmd.ExecuteReader();
while (msqldat.Read())
{
}
}
Hope, it helps :)