Adding a blank row to a datatable

[Roy]

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

[Richard Myers]

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

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:A3**********************************@microsof t.com...

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

[Roy]

Hi Richard,
As you guessed this is for reporting purpose. I was not able to run a sql
statement that returns a datatable with the blank rows. The datatable has
already been sorted and I need to loop through the rows and check for the
Number column. If there is a change then I need to insert a blank row that
each column has a value of NULL. To do this I've created another datatable
and when I'm looping through the original datatable if there is not a change
in this column I insert the oringinal row into the new datatable otherwise I
insert a new record with null values. This is working, but it doesn't look
very impresive and I wonder if there is a better way to do this.
Thanks again
Roy

"Richard Myers" wrote:

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

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:A3**********************************@microsof t.com...

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