I have table that looks like this:

ID_BILL XXXX YYYY
---------------------------------
1 aa bb
1 cc dd
1 fg 33
2 df fgb
2 dd 33

Now I want it to look like this:

ID_BILL XXXX YYYY
---------------------------------
1 aa bb
cc dd
fg 33
2 df fgb
dd 33

I want those munbers to be missing.

There is no way that I know of to make this happen automatically in the DataGridView.

You would need to modify the table manually to achieve this affect.

OR

There are third-party grid products that do this type of grouping.

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

Yes you have to do it programmatically.
you canmodify the values of the duplicate ids to "string.Empty" if its a string or null also.

- Paras

Hi,

There is one FAQ tells about this. Check the value, if duplicate, set the value to string.Empty. The FAQ also shows painting grouped DataGridView.

8. How to display grouped data in a DataGridView?

http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/thread/a44622c0-74e1-463b-97b9-27b87513747e#faq8

Best regards,

Ling Wang

---

Please remember to click “Mark as Answer�on the post that helps you, and to click “Unmark as Answer�if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

There is no way that I know of to make this happen automatically in the DataGridView.

You would need to modify the table manually to achieve this affect.

OR

There are third-party grid products that do this type of grouping.

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

Yes you have to do it programmatically.
you canmodify the values of the duplicate ids to "string.Empty" if its a string or null also.

- Paras

Where is your XXXX YYYYYY data coming from?

Are you reading from a file? Are the users entering it on your screen?

Is the ID_Bill also on the file or being entered, or is it sequentially assigend as the grid as built?

Hi,

There is one FAQ tells about this. Check the value, if duplicate, set the value to string.Empty. The FAQ also shows painting grouped DataGridView.

8. How to display grouped data in a DataGridView?

http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/thread/a44622c0-74e1-463b-97b9-27b87513747e#faq8

Best regards,

Ling Wang

---

Please remember to click “Mark as Answer�on the post that helps you, and to click “Unmark as Answer�if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.