Select Using .Net

[LIN]

Hi,

I have dataset which contains the data like this

TranDate PurchaseVal
------------ -------------
2003-01-01 51
2003-01-02 52
2003-01-03 54
2003-01-04 53
2003-01-05 54
2003-01-06 56
2003-01-07 58
2003-01-08 52
2003-01-09 51
2003-01-10 55

From this data I want weekly Info

Week Value
1 208
2 ---
3 ---

How I can get this

If I am using .Select("DatePart(week,TranDate)= " & 1)
it is giving me the error DatePart is not defines
Need Advice

LIN

[Armin Zingler]

"LIN" <ju******************@football.com> schrieb

Hi,

I have dataset which contains the data like this

TranDate PurchaseVal
------------ -------------
2003-01-01 51
2003-01-02 52
2003-01-03 54
2003-01-04 53
2003-01-05 54
2003-01-06 56
2003-01-07 58
2003-01-08 52
2003-01-09 51
2003-01-10 55

From this data I want weekly Info

Week Value
1 208
2 ---
3 ---

How I can get this

If I am using .Select("DatePart(week,TranDate)= " & 1)
it is giving me the error DatePart is not defines

This is an ADO.NET related question because the dataset is part of ADO.NET.
Please turn to microsoft.public.dotnet.framework.adonet.
--
Armin

[Herfried K. Wagner [MVP]]

Hello,

"LIN" <ju******************@football.com> schrieb:

I have dataset which contains the data like this

This is a VB.NET language group. Notice that you will have a better
chance to get an answer if you post to the ADO.NET newsgroup in future:

news://msnews.microsoft.com/microsof...amework.adonet

Web interface:

http://msdn.microsoft.com/newsgroups...amework.adonet

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
http://www.mvps.org/dotnet

[Jay B. Harlow [MVP - Outlook]]

LIN,
The best list I know of (only list I know of) that identifies what is
supported in Expressions in ADO.NET is:

http://msdn.microsoft.com/library/de...ssionTopic.asp

I do not see DatePart listed, so as the others have stated, you may want to
ask this 'down the hall' in the microsoft.public.dotnet.framework.adonet
newsgroup.

Hope this helps
Jay

"LIN" <ju******************@football.com> wrote in message
news:e0**************@TK2MSFTNGP11.phx.gbl...

Hi,

I have dataset which contains the data like this

TranDate PurchaseVal
------------ -------------
2003-01-01 51
2003-01-02 52
2003-01-03 54
2003-01-04 53
2003-01-05 54
2003-01-06 56
2003-01-07 58
2003-01-08 52
2003-01-09 51
2003-01-10 55

From this data I want weekly Info

Week Value
1 208
2 ---
3 ---

How I can get this

If I am using .Select("DatePart(week,TranDate)= " & 1)
it is giving me the error DatePart is not defines
Need Advice

LIN