Merge Table
Merge Case 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
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()
{
InitializeComponent();
}
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.
this.studentTableAdapter.Fill(this.studentDataSet.student);
// TODO: This line of code loads data into the 'studentDataSet.std1' table.
You can move, or remove it, as needed.
this.std1TableAdapter.Fill(this.studentDataSet.std1);
}
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=F:\\student.mdb");
OleDbDataAdapter ad = new OleDbDataAdapter("select * from std1", con);
DataTable tb1 = new DataTable();
ad.Fill(tb1);
dataGridView4.Visible = true;
dataGridView4.DataSource = tb1;
OleDbDataAdapter ad1 = new OleDbDataAdapter("select * from student", con);
DataTable tb2 = new DataTable();
ad1.Fill(tb2);
tb1.Merge(tb2);
dataGridView3.DataSource = tb1;
dataGridView3.Visible = true;
dataGridView1.Visible = false;
label1.Visible = false;
label2.Visible = false;
}
}
}
|
4)Run thr program
5)click the merge button
Data after Merge
No comments:
Post a Comment