title: how to get executed a query of two tables of same columns to datagridview columns only once in c# and Sql
body: <p>I got a strange problem
  I have 2 tables in sql database
  So I want to write a query which gives result of 2 tables data
  2 tables have same column names like    </p>
  
  <p>admission_number<br>
  student_name<br>
  student_class
  I want to execute that query as given Image  <img src="https://i.stack.imgur.com/xGdL9.png" alt="enter image description here">
  The data which is got after executing query will be loaded to datagridview of win-form coding in C#<br>
  I'm traing this using as below code,but its completly not related to my Issue, please help me.  </p>
  
  <pre><code> private void report()
      {
          dataGridView4.AutoResizeColumns();
          dataGridView4.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
  
  
          ConnectionStringSettings consettings = ConfigurationManager.ConnectionStrings["smssms"];
          string connectionString = consettings.ConnectionString;
          SqlConnection cn = new SqlConnection(connectionString);
  
          SqlCommand sqlcmd = new SqlCommand();
          SqlDataAdapter sda = new SqlDataAdapter();
          DataTable dt = new DataTable();
  
          cn.Open();
          //pass query 
  
          sqlcmd = new
  SqlCommand(@"selectt.admission_number,t.student_name,t.student_class,e.admission_number,e.student_name,e.student_class
  from tenthclass_marks as t,eighth_to_ninth_marks as e ", cn);
          sda = new SqlDataAdapter(sqlcmd);
          //Fill the data in the SQL Data Adapter
          sda.Fill(dt);
          //Bind it in the DataGrid View
          dataGridView4.DataSource = dt;
          cn.Close();
  
      }
  </code></pre>