1 2 3 4 5 6 7 8
| Public Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Dim _SQLTxt As String
_SQLTxt = "SELECT PD.products_id, PD.language_id, PD.products_name , P.products_model as products_model FROM products_description PD " & _
" Left join products P on P.products_id = PD.products_id " & _
" where products_name like '%" & txtTitleSearch.EditValue & "%' "
objDS.Tables("products_description1").Clear()
BKGlobal.Cls1.FillDataSet(objDS.Tables("products_description1"), _SQLTxt) '' Object reference not set to an instance of an object."
End Sub |