Hi Iam using this method to seach in xml file but it returns search by first word for example i have a name
Vbforums.com
and i write in seach box word "forum" then it will not return any result but if i write "vb" then it will return the result how to solve this problem code is here
HTML Code:Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click Dim b As Integer If TextBox10.Text <> "" And ComboBox1.Text <> "SELECT" Then Call sorting() Dim r As DataRow For b = 0 To (count - 1) If book.Tables(0).Rows(b).Item(ComboBox1.Text).ToString Like ((TextBox10.Text) & "*") Then a = b Call find() Exit For End If Next Else : MsgBox("parameters missing or incorect", MsgBoxStyle.Critical) End If Sub find() TextBox1.Text = book.Tables(0).Rows(a).Item("BookName") TextBox2.Text = book.Tables(0).Rows(a).Item("Author") TextBox3.Text = book.Tables(0).Rows(a).Item("Catgeory") TextBox4.Text = book.Tables(0).Rows(a).Item("Pages") TextBox5.Text = book.Tables(0).Rows(a).Item("DateAdded") TextBox6.Text = book.Tables(0).Rows(a).Item("DownloadLink") TextBox7.Text = book.Tables(0).Rows(a).Item("Description") TextBox8.Text = book.Tables(0).Rows(a).Item("Size") End Sub End Sub




Reply With Quote