如题,当需要对字符串进行对比的时候可以用like方法,以下是具体语句:
Dim sup, key As String
sup = ComboBox_quest_buy_buybl_supplyer.Text
key = tex_quest_buybl_key.Text
OleDbConnection2.Open()
OleDb_quest_taobao_buybl.SelectCommand.CommandText = "select * from buy_bl where [blno] like '%" + key + "%' " ‘作用是提取blno中包含key变量字符串的项
OleDb_quest_taobao_buybl.Fill(DataSet_quest_taobao_buybl1)
OleDbConnection2.Close()