Click here to Skip to main content
15,896,111 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questiondynamically populate the hashtable Pin
ferronrsmith16-Jul-07 10:47
ferronrsmith16-Jul-07 10:47 
AnswerRe: dynamically populate the hashtable Pin
Dave Kreskowiak16-Jul-07 13:28
mveDave Kreskowiak16-Jul-07 13:28 
GeneralRe: dynamically populate the hashtable Pin
ferronrsmith17-Jul-07 9:44
ferronrsmith17-Jul-07 9:44 
GeneralRe: dynamically populate the hashtable Pin
Dave Kreskowiak17-Jul-07 13:58
mveDave Kreskowiak17-Jul-07 13:58 
QuestionLabel Control Text Drifts Pin
T-Tops16-Jul-07 6:49
T-Tops16-Jul-07 6:49 
AnswerRe: Label Control Text Drifts Pin
Dave Kreskowiak16-Jul-07 7:06
mveDave Kreskowiak16-Jul-07 7:06 
AnswerRe: Label Control Text Drifts Pin
Luc Pattyn16-Jul-07 7:07
sitebuilderLuc Pattyn16-Jul-07 7:07 
QuestionMaking datetime field null, SQL Pin
aqzman_16-Jul-07 6:44
aqzman_16-Jul-07 6:44 
Hey guys, I have a question that I hope isn't too hard to get an anwser too, although even after all the Googling, and searching Code Project I've done I haven't had much luck yet.

What I'm trying to do is make a Datetime field in a SQL database null (it's already set to allow nulls), but no matter how many different ways I try I either get an error or the default lowest time is just filled in (1900/01/01 12:00:00 AM).

A time being there relys on the users input, so in some cases it might need to be filled in, in other cases it doesn't.

Anyway, here is my code, if anymore is needed just ask!

Dim DateClosed As Date
State = (ddlState.SelectedItem.Value)
If State = 0 Then
    DateClosed = CDate(lstYear2.SelectedValue & "/" & lstMonth2.SelectedValue & "/" & lstDay2.SelectedValue)
    Time = " " & ddlHour2.SelectedItem.Value + ":" + ddlMin2.SelectedItem.Value + ddlAMPM2.SelectedItem.Value
    DateClosed += Time
Else
    DateClosed = Nothing
End If


Just incase anyone needs to know, State is a drop down box with two selections. Open or closed. Open = 1 and Closed = 0.

Thanks,
aqzman
AnswerRe: Making datetime field null, SQL Pin
Dave Kreskowiak16-Jul-07 7:03
mveDave Kreskowiak16-Jul-07 7:03 
GeneralRe: Making datetime field null, SQL Pin
aqzman_16-Jul-07 7:31
aqzman_16-Jul-07 7:31 
GeneralRe: Making datetime field null, SQL [modified] Pin
Dave Kreskowiak16-Jul-07 7:39
mveDave Kreskowiak16-Jul-07 7:39 
GeneralRe: Making datetime field null, SQL Pin
aqzman_16-Jul-07 7:58
aqzman_16-Jul-07 7:58 
QuestionHard time finding good articles, need help Pin
Cory Kimble16-Jul-07 6:01
Cory Kimble16-Jul-07 6:01 
AnswerRe: Hard time finding good articles, need help Pin
Paul Conrad16-Jul-07 8:23
professionalPaul Conrad16-Jul-07 8:23 
GeneralRe: Hard time finding good articles, need help Pin
Cory Kimble16-Jul-07 9:56
Cory Kimble16-Jul-07 9:56 
GeneralRe: Hard time finding good articles, need help Pin
Paul Conrad16-Jul-07 10:09
professionalPaul Conrad16-Jul-07 10:09 
QuestionHow to get info from a file when it is being used by another process? Pin
Vivek Narayanan16-Jul-07 5:47
Vivek Narayanan16-Jul-07 5:47 
AnswerRe: How to get info from a file when it is being used by another process? Pin
Luc Pattyn16-Jul-07 6:49
sitebuilderLuc Pattyn16-Jul-07 6:49 
GeneralRe: How to get info from a file when it is being used by another process? Pin
Vivek Narayanan17-Jul-07 0:14
Vivek Narayanan17-Jul-07 0:14 
AnswerRe: How to get info from a file when it is being used by another process? Pin
Dave Kreskowiak16-Jul-07 6:55
mveDave Kreskowiak16-Jul-07 6:55 
QuestionIterate through child treenodes Pin
penguin500016-Jul-07 5:45
penguin500016-Jul-07 5:45 
AnswerRe: Iterate through child treenodes Pin
MidwestLimey16-Jul-07 7:21
professionalMidwestLimey16-Jul-07 7:21 
QuestionPDF/CHM Conversion Pin
phyrrix16-Jul-07 5:33
phyrrix16-Jul-07 5:33 
AnswerRe: PDF/CHM Conversion Pin
Nick Rioux16-Jul-07 6:15
Nick Rioux16-Jul-07 6:15 
Questione.graphics.fillpath Pin
Tom Deketelaere16-Jul-07 5:00
professionalTom Deketelaere16-Jul-07 5:00 

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.