 |
|
Code (SQL)
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)
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 & "')"
'str = "INSERT INTO TEST (A,B) VALUES ('1','13')"
'objCmd = New OleDbCommand(str, conn)
objCmd = New OleDbCommand
With objCmd
.Connection = conn
.CommandText = str
.CommandType = CommandType.Text
End With
Try
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 :
769 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
