vb.net 中select用法---like 字符串对比

 如题，当需要对字符串进行对比的时候可以用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()