Copy all data from datagridview to another datagridview

Question

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.

Ramesh Palanivel · Answer

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 Rednuk · Answer

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 Palanivel · Answer

Hi Nihcas, Here I haven't used any sql here. Just copy the data from datagridview1 to datagridview2. U can see the code!..

Nihcas Rednuk · Answer

Ramesh bhai , i dont want sql or database to be involved its just a display show model

Ramesh Palanivel · Answer

Hi Nihcas, Try my code, it will work....

Nihcas Rednuk · Answer

Please Check the image and try to figure out my question

Nihcas Rednuk · Answer

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 Shekhawat · Answer

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 Palanivel · Answer

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 { 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(); } }

Copy all data from datagridview to another datagridview

spgilmore