Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need advise for SQL statement
Message
From
10/11/2004 10:39:01
 
 
To
10/11/2004 06:05:21
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
VB.NET 1.1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00959905
Message ID:
00960009
Views:
10
Winan,

Have you tried running this code? If so, what is or is not happening? What did you expect to happen? I think it helps to post what you're actually seeing happening when you run code, instead of just to post it and ask if it's correct.

At a quick glance, all I see that may cause problems is:

Dim mFromDate As Date = C1DateEdit2.Text
Dim mToDate As Date = C1DateEdit2.Text

I think you'd need to convert or cast the .Text string to a DateTime data type.

~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Reply
Map
View

Click here to load this message in the networking platform