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]

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.

 

[Herfried K. Wagner [MVP]]

Hello,

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/microsoft.public.dotnet.framework.adonet

Web interface:

http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet

 

[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/d...fSystemDataDataColumnClassExpressionTopic.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