-
XML Search
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