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!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Filter DataView by Date Range
I am attempting to filter a dataview with the use of a Date Range. I am using two different DateTimePicker controls (dtpStartDate and dtpEndDate) Here is the code I am using: Dim _sDateRangeFilter as String _sDateRangeFilter = "dOrderDate > " & dtpStartDate.Value.Date & " AND < " &...- VBrian
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
-
Filter by Year from Date in DataView
I am trying to Filter by year and/or month in a date column of a dataview. For example: I would like to see(in my databound datagrid) all of the sales made in 2003(or whatever year is selected from a combo box). In Visual Basic I was able to perform this by using the following: (Where...- VBrian
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
SQL Stored Procedures With Parameters
I am currently building an n-tier application in VB.Net. I am using SQL Server 2000 as the database. I have created a simple stored procedure which returns a result set of two linked tables when given a single parameter value of "@SalesOrderID". This procedure works fine when calling it...- VBrian
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
"MoveLast" Equivalent in VB.Net
How does one determine the last record (with criteria)in a DataSet? My objective is to call up the last entry, matching certain criteria, and display the results. This was a simple task in VB6.0 with the statement: Recordset.MoveLast Is there a VB.Net equivalent? I understand that in VB.Net...- VBrian
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
