Click here to Skip to main content
15,885,737 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: vbcommenter Pin
helelark1239-Apr-08 21:46
helelark1239-Apr-08 21:46 
GeneralRe: vbcommenter Pin
Marc Soleda9-Apr-08 21:48
Marc Soleda9-Apr-08 21:48 
GeneralRe: vbcommenter Pin
helelark1239-Apr-08 22:56
helelark1239-Apr-08 22:56 
GeneralRe: vbcommenter Pin
Marc Soleda12-Apr-08 5:57
Marc Soleda12-Apr-08 5:57 
GeneralRe: vbcommenter [modified] Pin
helelark12312-Apr-08 22:11
helelark12312-Apr-08 22:11 
Questionhelp..urgent ..insert time to database [modified] Pin
Member 44429169-Apr-08 16:46
Member 44429169-Apr-08 16:46 
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 
ya...can't work i also donot know to do correct it

my sql
INSERT INTO `LOGIN/OUT` (`Log_No`, `LogIn_time`, `Login_Date`, `Emp_ID`) VALUES (?, dd-MM-yyyy, HH:mm:ss, ?) i'm not sure wheater correct...

and i change my code like this below..but stil can't work
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click<br />
 Dim Emp_IDDataRow As DataRow<br />
        Comdataset = Com.getCOMDataset<br />
<br />
 Emp_IDDataRow = Comdataset.EMPLOYEE_DETAIL.FindByEmp_ID(txtID.Text)<br />
        With Me<br />
            If Emp_IDDataRow IsNot Nothing Then<br />
                If txtPass.Text = Emp_IDDataRow!Password.ToString Then<br />
                    MessageBox.Show("Login Successful!", "infor", MessageBoxButtons.OK, MessageBoxIcon.Information)<br />
                    .LOGIN_OUTTableAdapter.InsertQueryEmp("ddmmyy,hhmmss", .Login_DateDateTimePicker.Value)<br />
                    .LOGIN_OUTTableAdapter.Fill(.Definition_dbDataSet._LOGIN_OUT)<br />
                Else<br />
                    .LOGIN_OUTTableAdapter.InsertQueryEmp("ddmmyy,hhmmss", .Login_DateDateTimePicker.Value)<br />
                    .LOGIN_OUTTableAdapter.Fill(.Definition_dbDataSet._LOGIN_OUT)<br />
                    Form2.Show()<br />
                End If<br />
            ElseIf Emp_IDDataRow IsNot Nothing Then<br />
                MessageBox.Show("Invalid Password!", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error)<br />
            ElseIf Emp_IDDataRow IsNot Nothing Then<br />
                MessageBox.Show("Invalid ID", "ERROR", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error)<br />
            End If<br />
        End With


error given was Syntax error (missing operator) in query expression 'HH:mm:ss'.

can anyone help me out..thanks in advanced
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 
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 

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.