错哪???谢谢

[zz0596]

Dim comstr As String
comstr = "insert into 工资表 values ('" & datastr & "'," & CmbNumber.Text & _
",'" & CmbName.Text & "','" & Txtheadship.Text & "'," & TxtWage.Text & _
"," & Txtbouns.Text & "," & TxtDP.Text & "," & TxtInsurance.Text & _
"," & TxtMulct.Text & ",'" & TxtReason.Text & "'," & TxtSum.Text & ") "

错误提示:: ','有语法错误

[pam]

数据表里的字段没有列出来？

看看语法吧
INSERT [INTO] table_or_view [(column_list)] data_values
例子：
INSERT INTO MyTable (PriKey, Description)
VALUES (123, 'A description of part 123.')

[Overriding]

你拼凑的sql里少了n多单引号，语法是insert into table(column1,column2...)values('values','value2'...)
如果插入的值是字符串需要都加上单引好，数字当然不用加。

如果省略了列，必须保证你要插入的每个列都有对应的值：insert into －－这里可以省略列－－table values()

[zz0596]

字段不用啊
没有'单引号的都是数字啊

[水如烟]

眼花.
这样定义不易错:
Dim INSERT_SALARY As String = "INSERT INTO 工资表 VALUES ('{0}','{1}',{2}....)"

[stone_soup]

楼主还可以从以下原因找:
1.Char型字段没有加音引号(')
2.是不是在全角环境下输入了逗号(,)

[zz0596]

谢谢啊,正在学

[苏良辰]

楼主，这样的帖子，也拿出来问！

晕死，没技术含量！

决定问别人前，先自己努力寻错，查资料，！

如果你不是搞程序的，就当我什么也没说