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");
}
}
