ADO.NET Projects

ADO.NET Project 1

ADO.NET Examples


Merge Table
Previous Home Next
  1. Different Table Structures,No Primary Key

    In the strongly typed DataSet, Table0 can be used as a sample table that has no primary keys defined on it.

  2. Binding the student datasource in table1 and table2
  3. write the code
    using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Windows.Forms;
    using System.Data.OleDb;
    namespace WindowsFormsApplication13
    public partial class Form1 : Form
    public Form1()
    private void Form1_Load(object sender, EventArgs e)
    // TODO: This line of code loads data into 
    //the 'studentDataSet.student' table. 
    You can move, or remove it, as needed.
    // TODO: This line of code loads data into 
    //the 'studentDataSet.std1' table. 
    You can move, or remove it, as needed.
    private void button1_Click(object sender, EventArgs e)
    OleDbConnection con = new OleDbConnection
    Data Source=F:\\student.mdb");
    OleDbDataAdapter ad = new OleDbDataAdapter("select * from std1", con);
    DataTable tb1 = new DataTable();
    dataGridView4.Visible = true;
    dataGridView4.DataSource = tb1;
    OleDbDataAdapter ad1 = new OleDbDataAdapter
    ("select * from student", con);
    DataTable tb2 = new DataTable();
    dataGridView3.DataSource = tb1;
    dataGridView3.Visible = true;
    dataGridView1.Visible = false;
    label1.Visible = false;
    label2.Visible = false; 

  5. Run thr program
  6. click the merge button
Previous Home Next