WHAT'S NEW?
Loading...
Showing posts with label command for search record. Show all posts
Showing posts with label command for search record. Show all posts

Visual Basic.Net provides features where you can automatically connect from your database source and query data in a simple way. In addition, you can query data directly from your database in various commands, such as adding, deleting, updating, and quick searching of record. Furthermore, a lot of controls can work with in querying a data in Visual Basic.Net with a less amount of code because of the .Net Framework provided. Fortunately, in this tutorial shows how to search record in Visual Basic.Net in a quick method. 

Here is the video in quick search command.


Source code:


Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'DbInfoDataSet.tblinfo' table. You can      move, or remove it, as needed.
        'Me.TblinfoTableAdapter.Fill(Me.DbInfoDataSet.tblinfo)
End Sub

Private Sub btnsearch_Click(sender As System.Object, e As System.EventArgs) Handles btnsearch.Click
      'move the code to txtsearch
End Sub

Private Sub txtsearch_TextChanged(sender As System.Object, e As System.EventArgs) Handles txtsearch.TextChanged

    Dim search As String = "%" + txtsearch.Text + "%"

    Me.TblinfoTableAdapter.FillBySearchName(Me.DbInfoDataSet.tblinfo, search, search)
End Sub