Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How do I write this?

Author  Topic 

JJ297
Aged Yak Warrior

940 Posts

Posted - 2010-03-17 : 11:20:24
I want the DB to load with today's date if nothing is in the DB. If something is in there then I want it to bring back the data.

If ("DteIn").ToString Is DBNull.Value Then
DteIntxt.Text = CType(DateTime.Now, Date).ToString("MM/dd/yyyy")
Else
DteIntxt.Text = rd("DteIn").ToString
End If

JJ297
Aged Yak Warrior

940 Posts

Posted - 2010-03-17 : 11:22:15
Never mind I got it!
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-18 : 03:36:36
Post the solution so that others can know it

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -