Hi all,
There are 20 rows that I am getting from database and I need to display the data in two datagrids.Please can any one help me out with a sample code in C#.I tried using dataview but no luck.

Please explain which criteria you want to use to determine which rows should go in the first grid and which in the second grid.

Hi,

Based on my understanding, you retrieve 20 rows from a database table and would like to show the first 10 rows in a DataGridView and the left 10 rows in the other DataGridView. If I'm off base, please feel free to let me know.

You canretrieve the 20 rows from database and fill them into a DataTable. Then add the latter 10 data rows in the DataTable into another DataTable and remove those data rows from the first DataTable. Bind one DataGridView to the first DataTable and bind the other DataGridView to the second DataTable by setting the DataSource property of the DataGridView to the DataTable).

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. end us any feedback you have about the help from MSFT at fbmsdn@microsoft.com.