copying the one gridview cell value to another gridview

[anuarthi]

Hi
i need to copy the one gridview cellvalue to another gridview
eg:
gridview1:
a b c
1 s 2
2 v 3
3 d 4

The Second Gridview Value Should Be
a g h
1
1
2
2
2
3
3
3
but i am getting the last value 3 in each row.
My Coding

ArrayList da1 = new ArrayList();
            ArrayList da2 = new ArrayList();
            int a1 = 0;
            int  a2 = 0;
 
           int id=0;
           foreach (GridViewRow row2 in grv2.Rows)
           {
               foreach (GridViewRow row1 in grv1.Rows)
               {
 
 
                   a1 = int.Parse(row1.Cells[3].Text);
                   da1.Add(a1);
                   da2.Add(a2);
 
 
                   foreach (int ir in da1)
                   {
                       if (id < ir)
                       {
 
                           row2.Cells[1].Text = row1.Cells[1].Text;
 
                       }
 
                   }
               }
 
        }
 

can any say me what is wrong in it

[Frinavale]

Why don't you try binding both GridViews to the same datasource...or even a copy of the DataSource?

[anuarthi]

i need to copy only the first column value of first gridview in second gridview Like

gridview1
a b c
1 s 4
2 sw 3

in the second gridview the values should be like
a h t
1
1
1
1
2
2
2

[rouse02]

humm... seems to me that this could be done with a query and then past that into the gridview.

List<column data type> bla = new List<column data type>();
 
for (int i = 0, i < System.Data.SqlClient.SqlCommand("Select Count(column name) From table"); i++)
{
  bla.Items.Add(System.Data.SqlClient.SqlCommand("Select column name From table Where primaryKeyID = @prim")
System.Data.SqlClient.SqlCommand.Parameters.Add("prim", System.Data.SqlDbType.column data type).Value = i;
}
 
New Gridview = bla;

Hope this helps.