> 
> How to do searching even though it isn't exact but will show in the datagridview
> 
> 
> 

[Datagridview](http://i.stack.imgur.com/Wbppe.png)

[Database](http://i.stack.imgur.com/CaTdT.png)

```
            OleDbCommand cmdDatabase = new OleDbCommand("Select User_ID, Firstname, Lastname, Pass, Account_Type from Account where Lastname'"+textBox1.Text+"'", con);
            try
            {

                OleDbDataAdapter sda = new OleDbDataAdapter();

                sda.SelectCommand = cmdDatabase;
                DataTable dbdataset = new DataTable();
                sda.Fill(dbdataset);
                BindingSource bSource = new BindingSource();

                bSource.DataSource = dbdataset;
                dataGridView1.DataSource = bSource;
                sda.Update(dbdataset);

            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

```