Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

retrieve data based on data range

Status
Not open for further replies.
skw8966

skw8966

Programmer
Apr 12, 2001
59
US
I have two textboxes (txtStartDate and txtEndDate). I would like to pull all data between those dates in a gridview. I can't seem to get the procedure to trigger.

Code: 
<%@ Page Language="vb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Variable Weekly Data</title>
</head>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<table>
  <tr>
    <td align="right">
      Start Date:
    </td>
    <td align="left">
      <asp:TextBox ID="txtStartDate" Runat="server" />
    </td>
    <td align="center">
      <a href="javascript:;" onclick="window.open('popup.aspx?textbox=txtStartDate','cal','width=250,height=225,left=270,top=180')">
      <img src="images/SmallCalendar.gif" border="0"></a>
    </td>
  </tr>
  <tr>
    <td align="right">
      End Date:
    </td>
    <td align="left">
      <asp:TextBox ID="txtEndDate" Runat="server" />
    </td>
    <td align="center">
      <a href="javascript:;" onclick="window.open('popup.aspx?textbox=txtEndDate','cal','width=250,height=225,left=270,top=180')">
      <img src="images/SmallCalendar.gif" border="0"></a>
    </td>
  </tr>
</table>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataSourceID="AccessDataSource1">
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" 
    DataFile="~/OrderCount.mdb" 
    SelectCommand="SELECT * FROM [qry3McWkCountRevised] WHERE (([RecDate] >= ?) AND ([RecDate] <= ?))">
    <SelectParameters>
        <asp:QueryStringParameter Name="RecDate" QueryStringField="txtStartDate" 
            Type="DateTime" />
        <asp:QueryStringParameter Name="RecDate2" QueryStringField="txtEndDate" 
            Type="DateTime" />
    </SelectParameters>
</asp:AccessDataSource>
</form>
</body>
</html>

Any ideas?
 
Sort by date Sort by votes
As Jason stated in your last post, do not use datasource controls.

You should look at using MS data access blocks.
 
Upvote 0 Downvote
Could you please explain what you mean by not using datasource controls?
 
Upvote 0 Downvote
The access datasource control:
Code: 
<asp:AccessDataSource ID="AccessDataSource1" runat="server" 
    DataFile="~/OrderCount.mdb" 
    SelectCommand="SELECT * FROM [qry3McWkCountRevised] WHERE (([RecDate] >= ?) AND ([RecDate] <= ?))">
    <SelectParameters>
        <asp:QueryStringParameter Name="RecDate" QueryStringField="txtStartDate" 
            Type="DateTime" />
        <asp:QueryStringParameter Name="RecDate2" QueryStringField="txtEndDate" 
            Type="DateTime" />
    </SelectParameters>
</asp:AccessDataSource>
 
Upvote 0 Downvote
According to the microsoft site, one of the requirements for using data access is a database server running SQL Server 7.0 or later. I'm using MS Access 2003. Do I have any other options?
 
Upvote 0 Downvote
I'm also using Visual Web Developer not Visual Studio
 
Upvote 0 Downvote
I don't know that to be the case, but if you read it then try using other data objects such as a dataadapter.
 
Upvote 0 Downvote
write the code. the more markup you write the less control you have over your app and the less debugging you can do. and unit testing it's an option at all.

use the code behind to set the datasource and bind the grid to the data. You may also run into problems using an access database on a web application because of the lock files and such. Access is best used for small, local, single user applications.

also MS' website is the worst place to find examples of good design patterns and practices. There site is great for finding out what an object does, but how to use that object is totally different. case in point XDataSourceControl. MSDN is great to find out what it does and all the members, but these controls are the worst idea ever.

My experience is WebForms encourages bad design. The more I work with them the more I fight the page life cycle.
1. it promotes drag/drop for html with serverside webcontrols
2. it creates a page life cycle doesn't exist anywhere else in web development
3. 99% of the examples promote the use of putting all the logic in the code behind. Which means you cannot unit test.
4. Webforms and webcontrols require parameterless ctors, which means inversion of control is either not supported, or requires noisy default ctors.

i'll get off my soap box now. In the end delete the asp:AccessDataSource control from your webform. enter the code behind and manually wireup the events and data to the grid.

Jason Meckley
Programmer
Specialty Bakers, Inc.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AhmedAzizBarbary
  • Locked
  • Question
How to read data response body after success login razor page ?
Replies
0
Views
420
AhmedAzizBarbary
AhmedAzizBarbary
G12Consult
  • Locked
  • Question
Retrieve data from JSON
Replies
1
Views
355
gmmastros
gmmastros
AhmedAzizBarbary
  • Locked
  • Question
How to pass list of checkboxes not checked on page model razor page?
Replies
0
Views
451
AhmedAzizBarbary
AhmedAzizBarbary
engsalah2018
  • Locked
  • Question
How to get label text from table reference on database based on TableName and FieldName
Replies
2
Views
370
jbenson001
jbenson001
baran121
  • Locked
  • Question
Sending data with bluetooth on webproject
Replies
1
Views
135
jbenson001
jbenson001

Part and Inventory Search

Sponsor

Back
Top