I am trying to set a filter button into my application and I need a little bit of help.. Acually I want the user enter the city of the customers (etc:Brampton-Ontario ) and the program prints out the customers of the ontario. If there aren't any records to print out a message. Below it's my code the program prints out the columns of city so that confused me.. Any ideas appreciate.!!!
Dim DataAdapter1 As MySqlDataAdapter = New MySqlDataAdapter() Dim sql4 As MySqlCommand = New MySqlCommand("SELECT City FROM customers = " & citytxt.Text, SQLConnection) Dim source1 As New BindingSource() Dim ds As DataSet = New DataSet() If citytxt.Text = "" Then MessageBox.Show("Error.Please fill the city or the mobile field", "Error Input.!", MessageBoxButtons.OK, MessageBoxIcon.Error) Else DataAdapter1.SelectCommand = sql4 ''database load DataAdapter1.Fill(ds, "customers") ''dataset source1.Filter = "customers = '" & citytxt.Text & " '" datagrid1.DataSource = ds datagrid1.DataMember = "customers" ''DATAGRIDVIEW Load data sources and datamember datagrid1.Refresh() SQLConnection.Close() ''closing/refreshing the connection
Thank you in advance..!!