/SQL/C# mysql data reader from two tables

C# mysql data reader from two tables

using (SqlConnection connection = new SqlConnection("connection string here"))
{
    using (SqlCommand command = new SqlCommand
           ("SELECT Column1 FROM Table1; SELECT Column2 FROM Table2", connection))
    {
        connection.Open(); 
        using (SqlDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                MessageBox.Show(reader.GetString(0), "Table1.Column1");
            }

            if(reader.NextResult())
            {
               while (reader.Read())
              {
                MessageBox.Show(reader.GetString(0), "Table2.Column2");
              }
            }
        }
    }
}

Source: stackoverflow.com

Similar codes

0 vote245 views1 answer
Add column to table with default value plsql
SQL
5 votes287 views1 answer
Oracle get ddl
SQL
0 vote234 views8 answers
Convert sql query to linq online
SQL
0 vote262 views1 answer
Restart sql server command line linux
SQL
0 vote274 views1 answer
How to delete python anywhere mysql database
SQL
0 vote258 views1 answer
Oracle query archivemode
SQL
6 votes274 views1 answer
How to get the size of the database in postgresql
SQL
1 vote243 views3 answers
Mariadb add foreign key
SQL
-1 vote244 views1 answer
Export mysql table to file
SQL
0 vote287 views1 answer
Mysql date without time
SQL