Click here to Skip to main content
15,905,874 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: help..urgent ..insert time to database Pin
Christian Graus9-Apr-08 17:35
protectorChristian Graus9-Apr-08 17:35 
GeneralRe: help..urgent ..insert time to database Pin
Member 44429169-Apr-08 18:10
Member 44429169-Apr-08 18:10 
GeneralRe: help..urgent ..insert time to database Pin
Christian Graus9-Apr-08 19:32
protectorChristian Graus9-Apr-08 19:32 
GeneralRe: help..urgent ..insert time to database Pin
Member 44429169-Apr-08 19:52
Member 44429169-Apr-08 19:52 
GeneralRe: help..urgent ..insert time to database Pin
Christian Graus9-Apr-08 19:56
protectorChristian Graus9-Apr-08 19:56 
GeneralRe: help..urgent ..insert time to database [modified] Pin
Member 44429169-Apr-08 20:05
Member 44429169-Apr-08 20:05 
GeneralRe: help..urgent ..insert time to database Pin
Christian Graus9-Apr-08 20:45
protectorChristian Graus9-Apr-08 20:45 
GeneralRe: help..urgent ..insert time to database [modified] Pin
Member 44429169-Apr-08 21:15
Member 44429169-Apr-08 21:15 
nop...this my assignment...coding i do myself..i get the query idea from update..i think is that similar..so i use update idea change to insert...actually how to function call in a stored proc to get the current date/time..can give some example..thanks

if i do another way it give me error also

Dim adpLogin As OleDbDataAdapter<br />
        Dim oleCommand As New OleDbCommand<br />
        Try<br />
            adpLogin = New OleDbDataAdapter<br />
            conDatabase.Open()<br />
            oleCommand.CommandText = "INSERT INTO [LOGIN] (Login_No, Login_Date, Login_Time, Staff_ID) " & _<br />
            "VALUES ('" & Format(Date.Today, "ddMMyyyy").ToString & Format(Date.Now, "HHmmss").ToString & _<br />
	    "', #" & Format(Date.Today, "dd/MM/yyyy") & "#, #" & Format(Date.Now, "H:mm:ss") & _<br />
	    "#, '" & txtUserID.Text.ToUpper() & "')"<br />
<br />
            oleCommand.Connection = conDatabase<br />
            adpLogin.InsertCommand = oleCommand<br />
            adpLogin.InsertCommand.ExecuteNonQuery()<br />
        Finally<br />
            conDatabase.Close()<br />
        End Try


the error is about condatabase.open

modified on Thursday, April 10, 2008 3:36 AM

GeneralRe: help..urgent ..insert time to database Pin
Christian Graus9-Apr-08 22:19
protectorChristian Graus9-Apr-08 22:19 
GeneralRe: help..urgent ..insert time to database [modified] Pin
Member 44429169-Apr-08 22:36
Member 44429169-Apr-08 22:36 
GeneralRe: help..urgent ..insert time to database Pin
Christian Graus10-Apr-08 0:05
protectorChristian Graus10-Apr-08 0:05 
GeneralRe: help..urgent ..insert time to database Pin
Member 444291610-Apr-08 3:38
Member 444291610-Apr-08 3:38 
GeneralRe: help..urgent ..insert time to database Pin
Christian Graus10-Apr-08 12:54
protectorChristian Graus10-Apr-08 12:54 
QuestionMessageBox stuck in loop Pin
Joe DiNatale9-Apr-08 16:05
Joe DiNatale9-Apr-08 16:05 
GeneralRe: MessageBox stuck in loop Pin
Johan Hakkesteegt9-Apr-08 20:09
Johan Hakkesteegt9-Apr-08 20:09 
GeneralRe: MessageBox stuck in loop Pin
Joe DiNatale10-Apr-08 4:58
Joe DiNatale10-Apr-08 4:58 
GeneralTrying to transfer data with filters. Pin
Dirtyd9-Apr-08 15:53
Dirtyd9-Apr-08 15:53 
GeneralRe: Trying to transfer data with filters. Pin
Dave Kreskowiak10-Apr-08 3:28
mveDave Kreskowiak10-Apr-08 3:28 
GeneralRe: Trying to transfer data with filters. Pin
Dirtyd21-Apr-08 2:34
Dirtyd21-Apr-08 2:34 
GeneralRe: Trying to transfer data with filters. Pin
Dave Kreskowiak21-Apr-08 3:45
mveDave Kreskowiak21-Apr-08 3:45 
GeneralRe: Trying to transfer data with filters. Pin
Dirtyd23-Apr-08 13:06
Dirtyd23-Apr-08 13:06 
GeneralExtending a class in Main.aspx.vb (inheritance) - newbie question. Pin
MadMaxToronto9-Apr-08 15:50
MadMaxToronto9-Apr-08 15:50 
GeneralRe: Extending a class in Main.aspx.vb (inheritance) - newbie question. Pin
Mycroft Holmes9-Apr-08 16:55
professionalMycroft Holmes9-Apr-08 16:55 
GeneralRe: Extending a class in Main.aspx.vb (inheritance) - newbie question. Pin
Dave Kreskowiak10-Apr-08 3:22
mveDave Kreskowiak10-Apr-08 3:22 
QuestionHaving a form in a VB.NET DLL file? Pin
LloydA1119-Apr-08 12:38
LloydA1119-Apr-08 12:38 

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.