Click here to Skip to main content
15,561,948 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Unique field Pin
Colin Angus Mackay21-Feb-07 0:28
Colin Angus Mackay21-Feb-07 0:28 
Questionread the long binary data Pin
lopashree20-Feb-07 20:34
lopashree20-Feb-07 20:34 
QuestionMultimedia in vb,net Pin
Hossein Narimani Rad20-Feb-07 20:06
Hossein Narimani Rad20-Feb-07 20:06 
QuestionHashing Pin
Radiit20-Feb-07 19:42
Radiit20-Feb-07 19:42 
AnswerRe: Hashing Pin
Dave Kreskowiak21-Feb-07 5:37
mveDave Kreskowiak21-Feb-07 5:37 
Questiondifference between Datagrid & datagridview Pin
priya_p23320-Feb-07 19:37
priya_p23320-Feb-07 19:37 
AnswerRe: difference between Datagrid & datagridview Pin
sathesh pandian20-Feb-07 20:00
sathesh pandian20-Feb-07 20:00 
QuestionSelect Record Between 2 Dates Pin
Kumaran21cen20-Feb-07 19:33
Kumaran21cen20-Feb-07 19:33 
Function SelectReportServiceAndDate(ByVal FromDt As Date, ByVal Todt As Date)
Try
'Myconnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=KanServicesDB.mdb;"
MyCommand.Connection = Myconnection
MyCommand.CommandText = "Select * from GKRST"
MyCommand.CommandType = CommandType.Text
MyDA.SelectCommand = MyCommand
MyDA.Fill(myDS, "GKRST1")
All.SetDataSource(myDS)
'All.RecordSelectionFormula = "{GKRST.Dttime}>=#" & Format(FromDt.Date, "mm/dd/yyyy") & "#"
All.RecordSelectionFormula = "{GKRST.DtTime}>=#" & Format(FromDt.Date, "M/dd/yyyy") & "# And {GKRST.DtTime}<=#" & Format(Todt.Date, "M/dd/yyyy") & "#"
'All.RecordSelectionFormula = "{GKRST.DtTime}>=#" & Now.AddDays(-1) & "# And {GKRST.DtTime}<=#" & Now & "#"
CrystalReportViewer1.ReportSource = All
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Function


Hi, I have a problem while selecting between two dates. In my database "Kanservices.mdb" have a Date Column like 'DtTime'. It has both date as well as time. The above code is select between two dates.Its not working properly. If i store the Date in the DtTime column its working. If i store Store Date&Time the problem occurs.

Plz give the solution.


Thanks & Regards
Kumaran

AnswerRe: Select Record Between 2 Dates Pin
Dave Kreskowiak21-Feb-07 5:36
mveDave Kreskowiak21-Feb-07 5:36 
QuestionBrowse the directory system Pin
ArchaBhandare20-Feb-07 19:00
ArchaBhandare20-Feb-07 19:00 
AnswerRe: Browse the directory system Pin
sathesh pandian20-Feb-07 19:15
sathesh pandian20-Feb-07 19:15 
GeneralRe: Browse the directory system Pin
ArchaBhandare20-Feb-07 19:29
ArchaBhandare20-Feb-07 19:29 
GeneralRe: Browse the directory system Pin
sathesh pandian20-Feb-07 19:42
sathesh pandian20-Feb-07 19:42 
GeneralRe: Browse the directory system Pin
ArchaBhandare20-Feb-07 19:55
ArchaBhandare20-Feb-07 19:55 
GeneralRe: Browse the directory system Pin
sathesh pandian20-Feb-07 22:41
sathesh pandian20-Feb-07 22:41 
GeneralRe: Browse the directory system Pin
ArchaBhandare20-Feb-07 23:10
ArchaBhandare20-Feb-07 23:10 
GeneralRe: Browse the directory system Pin
sathesh pandian20-Feb-07 23:24
sathesh pandian20-Feb-07 23:24 
GeneralRe: Browse the directory system Pin
ArchaBhandare20-Feb-07 23:31
ArchaBhandare20-Feb-07 23:31 
GeneralRe: Browse the directory system Pin
sathesh pandian20-Feb-07 23:38
sathesh pandian20-Feb-07 23:38 
GeneralRe: Browse the directory system Pin
ArchaBhandare20-Feb-07 23:41
ArchaBhandare20-Feb-07 23:41 
GeneralRe: Browse the directory system Pin
sathesh pandian20-Feb-07 23:44
sathesh pandian20-Feb-07 23:44 
GeneralRe: Browse the directory system Pin
ArchaBhandare20-Feb-07 23:49
ArchaBhandare20-Feb-07 23:49 
GeneralRe: Browse the directory system Pin
sathesh pandian20-Feb-07 23:56
sathesh pandian20-Feb-07 23:56 
GeneralRe: Browse the directory system Pin
ArchaBhandare21-Feb-07 0:01
ArchaBhandare21-Feb-07 0:01 
GeneralRe: Browse the directory system Pin
ArchaBhandare20-Feb-07 23:57
ArchaBhandare20-Feb-07 23:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.