Click here to Skip to main content
15,615,448 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi i have a sql database with a customer table.the datagridview is populated by using linq to sql.the customers is grouped by surname.
i want the datagridview to automatically insert an empty row before each group that starts with a different letter.
this is only neccessary for printing the datagridview and not to update the database.

if it is for printing the gridview, maybe you want to create a crystal report or any reorting tool to achieve this. :)
Share this answer
thanks iamsupergrasya
i got the problem solved by exporting an invisible datagridview to a csv file and at the same time grouping the customers by surname and inserting a blank row.i then import from the same csv file into another datagridview that is visible.from there on its just printing and the data in the database remains unmodified.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900