Link to home
Start Free TrialLog in
Avatar of RayT
RayTFlag for United States of America

asked on

Access/Visual Basic Question

I have the following AccessDataSource that returns the following columns

    <asp:AccessDataSource ID="PastWFTPs" runat="server" DataFile="~/App_Data/NSM.accdb" SelectCommand="SELECT * FROM [v_PastWFTPs]">
    </asp:AccessDataSource>
   
    Columns return
    ID                        Number
    WeekOf            Date/Time
    Title                  Short Text
    TheText            Long Text
    Inactive      Yes/No
    RecAdd            Date/Time
    RecMod            Date/Time
   
    How do I modify the following code to returns rows WeekOf within a particular range?
    How do I change this to accept parameters?
   
    For Each aRec As DataRowView In DirectCast(PastWFTPs.Select(DataSourceSelectArguments.Empty), DataView)
     'Do something'
    Next
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RayT

ASKER

Thanks!  That's what I was thinking.  Thanks again for confirming my idea.