'Number filling'

26 Oct 2006 12:30 PM

Edwin Knoppert

MDB, doing a max of a field which resultrs for example 12.
Now i want to simulate rows somehow (temptable?) with values 1 2 3 etc like:

1
2
3
4
5
6
7
8
9
10
11
12

It's all oledb asp.net 2, i'm not sure how to make such a temptable(memory
only) and fill this with 12 records via a query.
(This table is used in another query to make sure we have 12 periods, the
data we have might have period 1, 2, 10 etc.. but not all)

Thanks!

26 Oct 2006 1:13 PM

Miha Markic [MVP C#]

Why do you need it in first place?
One way is to create a DataTable instance, add one column and add 12 rows
accordingly.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"Edwin Knoppert" <n***@hellobasic.com> wrote in message
news:4540aadf$0$2014$ba620dc5@text.nova.planet.nl...
> MDB, doing a max of a field which resultrs for example 12.
> Now i want to simulate rows somehow (temptable?) with values 1 2 3 etc
> like:
>
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> 10
> 11
> 12
>
> It's all oledb asp.net 2, i'm not sure how to make such a temptable(memory
> only) and fill this with 12 records via a query.
> (This table is used in another query to make sure we have 12 periods, the
> data we have might have period 1, 2, 10 etc.. but not all)
>
> Thanks!
>
>

26 Oct 2006 1:55 PM

Edwin Knoppert

I'm trying to prepare a single querystatement.
Select in select and such, so i can use and spread the query to someone
else.
Long story..

Show quote

"Miha Markic [MVP C#]" <miha at rthand com> schreef in bericht
news:%2336haCQ%23GHA.4800@TK2MSFTNGP05.phx.gbl...
> Why do you need it in first place?
> One way is to create a DataTable instance, add one column and add 12 rows
> accordingly.
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "Edwin Knoppert" <n***@hellobasic.com> wrote in message
> news:4540aadf$0$2014$ba620dc5@text.nova.planet.nl...
>> MDB, doing a max of a field which resultrs for example 12.
>> Now i want to simulate rows somehow (temptable?) with values 1 2 3 etc
>> like:
>>
>> 1
>> 2
>> 3
>> 4
>> 5
>> 6
>> 7
>> 8
>> 9
>> 10
>> 11
>> 12
>>
>> It's all oledb asp.net 2, i'm not sure how to make such a
>> temptable(memory only) and fill this with 12 records via a query.
>> (This table is used in another query to make sure we have 12 periods, the
>> data we have might have period 1, 2, 10 etc.. but not all)
>>
>> Thanks!
>>
>>
>
>