4
Answers

data copying b/w 2 tables ?

Hi buddies
 
well say i have table with data .. i want to copy the same data to other table ..
 
PS : Here copy() should not be used .. Well i know there is  a way to achieve this i.e using clone and later Rows.add() ..
 
But I NEED IS , CAN ANYONE correct the stupid code i written i.e data copying b/w tables via datasetsusing forLoop  ?/
 
My code so far :
 
private void Form1_Load(object sender, EventArgs e)
{
con = new SqlConnection("Data Source=sunil-pc;Initial Catalog=formdb;User ID=sa;Password=123");
SqlCommand cmd = new SqlCommand("select * from formtable", con);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "table1");
dataGridView1.DataSource = ds.Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
DataSet ds1 = new DataSet();
int columns = ds.Tables[0].Columns.Count;
int rows = ds.Tables[0].Rows.Count;
for (int i = 0; i < rows; i++)
{
for (int j = 1; j < columns + 1; j++)
{
ds1.Tables[0].Rows[i][j] = ds.Tables[0].Rows[i][j];
}
}
dataGridView2.DataSource = ds1.Tables[0];
}
 
 Well i hope i am clear :) Ty for help 
 
Have a nice day :) 

Answers (4)