Question

VB中用ADO删除数据库一条记录的问题,高手进!

Dim CNN As New ADODB.Connection
Dim RST As New ADODB.Recordset
Dim SQL As String
CNN.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=HotelRoom;Data Source=."
RST.Open CNN.ConnectionString
SQL = "delete from RoomInfo where Rnum='" & DataCombo2.Text & "'"
CNN.Execute SQL
RST.Close
Set DataGrid2.DataSource = Adodc5
DataGrid2.Refresh

执行后没反应,不知道怎么回事,请高手指点!
最后两句不需要管他,只要帮我看看前面的代码有什么问题,删除不了指定的记录

Answer 1

trim一下DataCombo2.Text