>< I am so sorry. I am used to trolling the ASP.NET/C#/VB
.NET forums that i posted C# code. Wow.
You would have to do something like this:
sDate1 = CStr(Request.Form("txtDate1")) & " " & CStr(Request.Form("txtTime1"))
sDate2 = CStr(Request.Form("txtDate2")) & " " & CStr(Request.Form("txtTime2"))
sSql = "SELECT * from [table] where [date] between '" & sDate1 & "' AND '" & sDate2 &"'"
This, of course, is the dynamic sql approach. You could just as easily pass sDate1 and sDate2 into a stored procedure.
Read this if you want to know how to get a correct reply for your question:
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0