private void txtNameItem_TextChanged(object sender, EventArgs e) { if (txtNameItem.Text.Trim() != string.Empty) { dgV_Items.DataSource = _item.GetTableItemsMySQL_ToName(txtNameItem.Text); } }
void AddDataToDGView(string num, string NameItem) { if (NameItem != null) { DataTable add = _item.GetTableItemsMySQL_ToName(NameItem); string id = add.Rows[0][0].ToString(); string name = add.Rows[0][1].ToString(); string number = num; string unit = add.Rows[0][3].ToString(); if (dgv_ContentItem.Rows.Count == 0) { string[] row = new string[] { id, name, unit, number }; dgv_ContentItem.Rows.Add(row); ColorData(); } else { int r = dgv_ContentItem.Rows.Count; for (int i = 0; i < r; i++) { if (id.Equals(dgv_ContentItem.Rows[i].Cells["ID"].Value.ToString())) { XtraMessageBox.Show("Vật tư bạn chọn đã có rồi !"); return; } } string[] row = new string[] { id, name, unit, number }; dgv_ContentItem.Rows.Add(row); ColorData(); } } }