WHAT'S NEW?
Loading...

Visual Basic quick search command


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

2 comments: Leave Your Comments

  1. thnx, nice work. but no any source code.

    ReplyDelete
  2. Learned a lot of

    new things from your post!Good creation ,thanks for good info .

    Net Online Training Hyderabad

    ReplyDelete