Merge Case 5: Absolutely Different Table Structures
In this case, the two table structures have nothing in common. All the columns differ2) create the different column
DataTable ftb = new DataTable();
DataTable stb = new DataTable();ftb.Columns.Add("Sno", typeof(Int32));
ftb.Columns.Add("Sname", typeof(String));
ftb.PrimaryKey = new DataColumn[] { ftb.Columns["Sno"] };
stb.Columns.Add("Smark", typeof(Int32));
stb.Columns.Add("Sgrade", typeof(String));
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 WindowsFormsApplication15 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } DataTable ftb = new DataTable(); DataTable stb = new DataTable(); private void Form1_Load(object sender, EventArgs e) {
ftb.Columns.Add("Sno", typeof(Int32));
ftb.Columns.Add("Sname", typeof(String));
// ftb.PrimaryKey = new DataColumn[] { ftb.Columns["Sno"] };
ftb.LoadDataRow(new object[] { "1", "Ashish" }, true); ftb.LoadDataRow(new object[] { "2", "KAMAL" }, true);
ftb.LoadDataRow(new object[] { "3", "Mohit" }, true); ftb.LoadDataRow(new object[] { "4", "Aditya" }, true);
stb.Columns.Add("Smark", typeof(Int32));
stb.Columns.Add("Sgrade", typeof(string));
stb.LoadDataRow(new object[] { "480", "I" }, true); stb.LoadDataRow(new object[] { "255", "II" }, true); stb.LoadDataRow(new object[] { "295", "II" }, true); stb.LoadDataRow(new object[] { "380", "I" }, true); dataGridView1.DataSource = ftb; dataGridView2.DataSource = stb; }
private void button1_Click(object sender, EventArgs e) { ftb.Merge(stb); dataGridView3.DataSource=ftb; dataGridView1.Visible = false; dataGridView2.Visible = false; dataGridView3.Visible =true; label1.Text = "After Merging"; label2.Visible = false; } } }
|
4)Run the program
0 comments:
Post a Comment