Search results for query: *

Thanks dalchri! That's all it took! Working like a charm.

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 < " &...

There may well be, or at least there should be a simpler solution than I will show here, but after struggling with this same issue the other day, I found that the following will at least work. When searching the help index in VB.Net it indicates that you should use the "RemoveAt" method of the...

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...

Stop the press! I've made a giant foopa! As I went back to the problem (right after initiating this thread, of course), I discovered that the error was in the database, not the code. I am using a temporary database while writing the application and discovered that there were records which...

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...

Thank you for your reply Craig. Please forgive my ignorance, but I am still having problems accomplishing what I need to do. I have looked up &quot;TOP&quot; in VS.NET Help and the description of what it can do is there, but no examples of how to implement it into my SQL statement. I have...

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...

I am also trying to make the migration from VB6 to VB.Net and can sympathize with the frustrations you are experiencing. I did come across the same problem and after much trial and error was able to actually update the Access 2000 database. Without seeing your entire code, it is difficult to...