Hi all,
I do have a datatable that looks like:
id   Number   Description
1    1             Desc1
2    1             Desc2
3    2             Desc3
I need this datatable looks like (with 4 rows which the third one is blank):
id   Number   Description
1    1             Desc1
2    1             Desc2

3    2             Desc3
Any suggestions would be appreciated.
Roy

Hi Roy,

Thats doesn;t really make sense. One of the primary tenants of a relational
databases is the the order of the rows is unimportant. Secondly why would
you want to store NOTHING?

If this is for some kind of output/report then you'd be better of telling
us what you're doing so we can advise with a another code based strategy.
If you want to stick with your blank row then you'll be relying on
inserting NULLs /and or white space. This will not be possible however if
your Id column is autonumbered/incrementing.

This will still not get you around any sorting however because this null
row will be placed at either the top or the bottom when sorted.

Richard

Show quoteHide quote

Why use a module instead of class?
An absence of IntelliSense in this situation
Making trial version
creating an array as property of a class
Question about Namespaces and the Object Browser.
Hierarchal recordset
Creating a custom log
Installing VS.NET 2005 Beta 1
disable items in CheckBoxList
transparancy in vb.net