asp.net 执行SQL命令的问题

[沉默老哥]

cmD.CommandText = "SELECT * FROM hetong where type=" & TextType & " And htbhao=" & TextHTBhao

adOpenStatic = 3
adLockBatchOptimistic = 4
Rst1.CursorLocation = ADODB.CursorLocationEnum.adUseClient 'adUseClient '定义Recordset游标的位置
Rst1.Open(cmD, , adOpenStatic, adLockBatchOptimistic)
错误提示：
'语法错误 (操作符丢失) 在查询表达式 'type = 24018CA/W33 And htbhao = 201003002' 中。
问题在何处？

[kyoybs]

cmD.CommandText = "SELECT * FROM hetong where type='" & TextType & "' And htbhao='" & TextHTBhao &"'"
注意单引号

[wkzhx]

SQL语句写错了，字符串要加''

 "SELECT * FROM hetong where type='" & TextType & "' And htbhao='" & TextHTBhao & "'"

[bigmingming]

24018CA/W33 字符有个 /

[小鹏]

type是关键字，在数据表设计的时候最好不要把保留字设成字段。

[沉默老哥]

谢谢各位楼主的帮助，在此万分感谢