/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 vote144 views1 answer
Sql server on mac m1
SQL
2 votes149 views1 answer
Sql get the name of user pc
SQL
13 votes135 views2 answers
Get tables in database sql
SQL
14 votes127 views2 answers
How to auto increment in sql
SQL
0 vote132 views1 answer
Mariadb current date plus 1 day
SQL
8 votes127 views1 answer
Unique vs primary key
SQL
1 vote97 views1 answer
Unique vs distinct sql
SQL
0 vote181 views1 answer
Sql alter table add column if exists
SQL
1 vote119 views1 answer
What is int in mysql
SQL
1 vote139 views1 answer
Nullif postgresql
SQL