Copy all data from datagridview to another datagridview

Nihcas Rednuk

I have created a windows form(C#), in which i have two datagridview .

datagridview1 has 7 columns (Like Sr.no, Name, Class,Div,Rank,Age,City)

and datagridview2 has 4 column(Like Sr.no, Name, Class,City)

i want to copy all the data from the datagridview1 to datagridview2 by a button click, in such a way that my datagridview2 displays all the data from datagridview1.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
Hi Nihas,

Yes!.. I know your requirement exactly!.. Here I have just used some sample data to copy!.. You can use my code which was written in button3_click event.. Just copy the code and use #it.. It should work.. Copy the code and paste it on your button click event..

Note ( Here I have copied only three columns from datagridview1 to datagridview2.. change it on depends on your requirement)
Nihcas Rednuk9y ago
A thousand thanks to Ramesh Palanivel, but ramesh bhai , adding test is not what i need, i will insert data on runtime so that all data inserted will be shown in datagridview1 by a single button click and after all my data is inserted in datagridview1, i want another button for buttonclick to copy all data from datagridview1 to datagridview2 (without selecting any row).So if you have any idea please let me know..
Ramesh Palanivel9y ago
Hi Nihcas,

Here I haven't used any sql here. Just copy the data from datagridview1 to datagridview2.

U can see the code!..
Nihcas Rednuk9y ago
Ramesh bhai , i dont want sql or database to be involved its just a display show model
Ramesh Palanivel9y ago
Hi Nihcas,

Try my code,

it will work....
Nihcas Rednuk9y ago
Please Check the image and try to figure out my question
Nihcas Rednuk9y ago
i have watched the videos but you see i dont want to select nor i want to include in database i just want to show data from datagridview to another.
For instance, during runtime data is inserted in datagridview1 and when i click a button it should display the datagridview1 data into datagridview2. ( no selection nor database included)
Jitendra Shekhawat9y ago
https://www.youtube.com/watch?v=_iJuxh08TdQ

https://www.youtube.com/watch?v=3Vum8uhzLNc

https://www.daniweb.com/programming/software-development/threads/266987/adding-data-from-datagridview-to-another-datagridview
Ramesh Palanivel9y ago
Hi Nihcas,
R u binding data in database , its easy using simple sql query.. If you want to copy the data from datagridview1 to datagridview 2 , try the below code,
private void Form4_Load(object sender, EventArgs e)
        {
            dataGridView1.Rows.Add();
            dataGridView1.Rows.Add();
            dataGridView1.Rows[0].Cells[0].Value = "test";
            dataGridView1.Rows[0].Cells[1].Value = "test";
            dataGridView1.Rows[0].Cells[2].Value = "test";
            dataGridView1.Rows[0].Cells[3].Value = "test";
            dataGridView1.Rows[1].Cells[0].Value = "test";
            dataGridView1.Rows[2].Cells[1].Value = "test";
            dataGridView1.Rows[3].Cells[2].Value = "test";
            dataGridView1.Rows[4].Cells[3].Value = "test";
}

private void button3_Click(object sender, EventArgs e)
        {


            for (int i = 0; i < dataGridView1.Rows.Count-1;i++ )
            {
                dataGridView2.Rows.Add();
                dataGridView2.Rows[i].Cells[0].Value = dataGridView1.Rows[i].Cells[0].Value.ToString();
                dataGridView2.Rows[i].Cells[1].Value = dataGridView1.Rows[i].Cells[1].Value.ToString();
                dataGridView2.Rows[i].Cells[2].Value = dataGridView1.Rows[i].Cells[2].Value.ToString();
                dataGridView2.Rows[i].Cells[2].Value = dataGridView1.Rows[i].Cells[2].Value.ToString();
            }

        }