نام جدول users
عبارک مورد جستجو search
con2.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = con2;
da.SelectCommand.CommandType = CommandType.Text;
da.SelectCommand.CommandText = "select * from users where name like '%search%' ";
DataTable dt = new DataTable();
da.Fill(dt);
con2.Close();
DataView view1 = new DataView(dt);
CurrencyManager cur;
cur = (CurrencyManager)(this.BindingContext[view1]);
if (cur.Count == 0)
MessageBox.Show("Not Found", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
else
dataGridView1.DataSource = dt;