Listview Search Function (MySql)
This tutorial shows you how to make a search function in your listview control with MySql.
Demonstration on how it works:
Download MySql.Data.dll
Click here to download the *.dll file!
Now add the dll to your references!
So to start with create a new project and add the following controls:
- 1 Textbox
- 1 Combobox
- 2 Labels
Now make it look like this:
[img]http://dl.dropbox.com/u/48593307/Billeder/tut1.png[/img]
Add all the rows that you have in your database to the Combobox items.
Note: On my project this search form is one for itself, and then it searches on another form, so you have to make this under the same form as where your listview is!
Below 'Public Class (YourProjectName)' add the following code:
PHP Code
<?php
Dim ds As New DataSet
Dim strSQL As String
Dim cmd As New MySqlCommand
Dim dr As MySqlDataReader
Dim a, b, c, d, f, g, h, i, j, k
Dim ConnString As String = "SERVER = localhost; USERID = root; PASSWORD = root; DATABASE = dbname"
Dim CONNECTION As New MySqlConnection(ConnString)
Add as many letters as your listview columns has.
After this double click on the textbox, make sure that it handles TextChanged! Now add this code:
PHP Code
<?php
Private Sub TextBox1_TextChanged(sender As System.Object, e As System.EventArgs) Handles TextBox1.TextChanged
strSQL = "SELECT * from dbname where " & ComboBox1.Text & " like '%" & TextBox1.Text & "%'"
CONNECTION.Open()
cmd = New MySqlCommand(strSQL, CONNECTION)
dr = cmd.ExecuteReader()
ListView1.Items.Clear()
Do While dr.Read()
a = (dr.Item("column1").ToString())
b = (dr.Item("column2").ToString())
c = (dr.Item("column3").ToString())
d = (dr.Item("column4").ToString())
f = (dr.Item("column5").ToString())
g = (dr.Item("column6").ToString())
h = (dr.Item("column7").ToString())
Dim lv As ListViewItem = ListView1.Items.Add(a)
lv.SubItems.Add(b)
lv.SubItems.Add(c)
lv.SubItems.Add(d)
lv.SubItems.Add(f)
lv.SubItems.Add(g)
lv.SubItems.Add(h)
Loop
dr.Close()
CONNECTION.Close()
cmd.Dispose()
End Sub
Edit the column1 and the others to your database column names!
I hope that you learned something from this! 🤝
Take care!