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 ClassDivRankAgeCity) and datagridview2 has 4 column(Like Sr.no Name ClassCity) 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(); } }