help please!

[ching]

how do i compare current system date in vb.net with a date stored in ms sql(table name is A and column name is B) to see whether which is later.

EggHeadCafe - Software Developer Portal of Choice
SQL Server - Save Image To Database in .NET
http://www.eggheadcafe.com/tutorial...b9-5307357e0fef/sql-server--save-image-t.aspx

 

[Rich P]

Dim dt1, dt2 As Date

dt1 = Now
dt2 = CDate("10/1/09") 'or date from a sql server table
If dt1 > dt2 Then
Console.WriteLine("greater")
Else
Console.WriteLine("less")
End If

Rich

 

[Cor Ligthert[MVP]]

Assuming that you made the connection and the command

If CDate(myCommand.ExecuteScalar)<>Now then


in message news:[email protected]...