private void Form2_Load()
{
SupplierLV.Clear();
SupplierLV.View = View.Details;
SupplierLV.GridLines = true;
SupplierLV.FullRowSelect = true;
//Add column header
SupplierLV.Columns.Add("ID", 50);
SupplierLV.Columns.Add("Name", 70);
SupplierLV.Columns.Add("Website", 140);
SupplierLV.Columns.Add("Twitter", 70);
SupplierLV.Columns.Add("Email", 120);
SupplierLV.Columns.Add("Phone", 100);
//load date from Database
DataTable data = SQLConnect.Selects("Select SupplierID, SupplierName, WebsiteAddress, TwitterAccount, Email, Phone from SUPPLIER;", 6);
//Add first item
int index = 1;
foreach (DataRow row in data.Rows)
{
//Add items in the listview
ListViewItem Supplier = new ListViewItem(row[0].ToString());
Supplier.SubItems.Add(row[1].ToString());
Supplier.SubItems.Add(row[2].ToString());
Supplier.SubItems.Add(row[3].ToString());
Supplier.SubItems.Add(row[4].ToString());
Supplier.SubItems.Add(row[5].ToString());
SupplierLV.Items.Add(Supplier);
index++;
}
}
private void refreshBT_Click(object sender, EventArgs e)
{
SupplierLV.Clear();
Form2_Load();
}
