databound datagridview add empty row

Question

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.
thanks

Posted 11-Jul-12 8:15am

Kleinyster

Add a Solution

2 solutions

Solution 1

if it is for printing the gridview, maybe you want to create a crystal report or any reorting tool to achieve this. :)

Posted 11-Jul-12 21:27pm

graciax8

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Kleinyster · Accepted Answer · 2012-07-11T21:39:00

SQL

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.
kleinyster