how can i these record to previews Table by new identity Primary key ?
If it just about displaying the data twice then no need to insert duplicate data in your table simply follow the guidelines below
OleDbConnection con = new OleDbConnection ();
con.ConnectionString = "your connection string here";
con.Open();
OleDbCommand cmd=new OleDbCommand();
cmd.CommandText = "Select * from dbo_NR_HMSWD50SQ_01_147";
OleDbDataAdapter adp = new OleDbDataAdapter(cmd.CommandText , con);
DataTable ds = new DataTable();
DataTable ds1 = new DataTable();
adp.Fill(ds);
adp.Fill(ds1);
ds.Merge(ds1);
dataGridView1.DataSource = ds;
I hope this helps you........