private void btnGetAllData_Click(object sender, EventArgs e) { //Clear ListView before loading new data lvwDisneyCharacter.Items.Clear(); DataTable dataTable = CRUD.getAllDocument(); DataRow[] rulesRow = dataTable.Select(); foreach (DataRow row in rulesRow) { id = row[0].ToString(); name = row[1].ToString(); originalVoiceActor = row[2].ToString(); animatedDebut = row[3].ToString(); //Add item to listview arrCharacter[0] = id; arrCharacter[1] = name; arrCharacter[2] = originalVoiceActor; arrCharacter[3] = animatedDebut; itm = new ListViewItem(arrCharacter); lvwDisneyCharacter.Items.Add(itm); } }
public Form1() { InitializeComponent(); lvwDisneyCharacter.Items.Clear(); DataTable dataTable = CRUD.getAllDocument(); DataRow[] rulesRow = dataTable.Select(); foreach (DataRow row in rulesRow) { id = row[0].ToString(); name = row[1].ToString(); originalVoiceActor = row[2].ToString(); animatedDebut = row[3].ToString(); //Add item to listview arrCharacter[0] = id; arrCharacter[1] = name; arrCharacter[2] = originalVoiceActor; arrCharacter[3] = animatedDebut; itm = new ListViewItem(arrCharacter); lvwDisneyCharacter.Items.Add(itm); } }
private void btnGetAllData_Click(object sender, EventArgs e) { //Clear ListView before loading new data lvwDisneyCharacter.Items.Clear(); DataTable dataTable = CRUD.getAllDocument(); DataRow[] rulesRow = dataTable.Select(); foreach (DataRow row in rulesRow) { id = row[0].ToString(); firstname = row[1].ToString(); lastname = row[2].ToString(); city = row[3].ToString(); //Add item to listview arrCharacter[0] = id; arrCharacter[1] = firstname; arrCharacter[2] = lastname; arrCharacter[3] = city; itm = new ListViewItem(arrCharacter); lvwDisneyCharacter.Items.Add(itm); } }
private void btnIndex_Click(object sender, EventArgs e) { bool status; id = tbxID.Text; name = tbxName.Text; originalVoiceActor = tbxVoiceActor.Text; animatedDebut = tbxDebut.Text; status = CRUD.insertDocument(id, name, originalVoiceActor, animatedDebut); lvwDisneyCharacter.Items.Clear(); DataTable dataTable = CRUD.getAllDocument(); DataRow[] rulesRow = dataTable.Select(); foreach (DataRow row in rulesRow) { id = row[0].ToString(); name = row[1].ToString(); originalVoiceActor = row[2].ToString(); animatedDebut = row[3].ToString(); //Add item to listview arrCharacter[0] = id; arrCharacter[1] = name; arrCharacter[2] = originalVoiceActor; arrCharacter[3] = animatedDebut; itm = new ListViewItem(arrCharacter); lvwDisneyCharacter.Items.Add(itm); } if (status == true) { MessageBox.Show("Thêm dữ liệu thành công!"); } else { MessageBox.Show("Thao tác sai! Đã có dữ liệu này rồi"); } }