 |
|
Code (SQL)
1.INSERT INTO USRNAME (USRNAME,PASS,NAME,LASTNAME,POSITION,DEPARTMENT,INPUTDATE,STAT,REQUESTDATE ) VALUES ('test','test','test','test','test','test','27-07-2013 03:39:32 PM','Active','27-07-2013 03:39:32 PM')
Syntax error in INSERT INTO statement.
USRNAME text
PASS text
NAME text
LASTNAME text
POSITION text
DEPARTMENT text
INPUTDATE date/time
STAT text
REQUESTDATE date/time
Code (VB.NET)
01.str = "INSERT INTO USRNAME (USRNAME,PASS,NAME,LASTNAME,POSITION,DEPARTMENT,INPUTDATE,STAT,REQUESTDATE ) VALUES ('" & txtUSRNAME.Text & "','" & txtPASS.Text & "','" & txtName.Text & "','" & txtSurname.Text & "','" & txtPOSITION.Text & "','" & txtDEPT.Text & "','" & DateTimePicker1.Value & "','" & txtSTATUS.Text & "','" & txtREQDATE.Value & "')"
02.
03.
04.
05.objCmd = New OleDbCommand
06.With objCmd
07..Connection = conn
08..CommandText = str
09..CommandType = CommandType.Text
10.End With
11.Try
12.objCmd.ExecuteNonQuery()
แต่สามารถรัน คิวรี่ บน access ผ่านนะครับ แต่ insert ผ่าน โปรแกรมไม่ผ่าน
Tag : .NET, Ms Access
|
ประวัติการแก้ไข
2013-07-27 15:54:58
|
 |
 |
 |
 |
| Date :
2013-07-27 15:51:25 |
By :
tavada_b |
View :
773 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
