private void KhoiTao() { if (grdvDSNhaCungCap.ColumnCount > 0) { grdvDSNhaCungCap.Columns.Clear(); grdvDSNhaCungCap.DataSource = null; bindingSource1 = new BindingSource(); } DataTable Bang; Bang = NhaCungCapBus.LayBang(); //Loc thong tin mat hang bindingSource1.DataSource = Bang; string sql = ""; if (radioTatCa.Checked == false) { if (radioTheoMa.Checked == true) { sql = " CONVERT([MaNhaCungCap], 'System.String') = '" + txtNhaCungCap.Text.Trim() + "' "; } else { sql = " CONVERT([TenNhaCungCap], 'System.String') LIKE '%" + txtNhaCungCap.Text.Trim() + "%' "; } if (txtNhaCungCap.Text.Trim() != "") { bindingSource1.Filter = sql; } else { } } grdvDSNhaCungCap.DataSource = bindingSource1; AnCotTrenLuoi(); DinhDangCot(); }