private void buttonList_Click(object sender, EventArgs e)
        {
            listViewClient.Items.Clear();
            dsClient = UtilityDB.GetDataSetClients(dsClient, dtClient);

            foreach (DataRow row in dtClient.Rows)
            {
                ListViewItem item = new ListViewItem(row["ClientId"].ToString());
                item.SubItems.Add(row["ClientName"].ToString());
                item.SubItems.Add(row["Phone"].ToString());
                item.SubItems.Add(row["CreditLimit"].ToString());
                item.SubItems.Add(row["StreetNumber"].ToString());
                item.SubItems.Add(row["StreetName"].ToString());
                item.SubItems.Add(row["City"].ToString());
                item.SubItems.Add(row["PostalCode"].ToString());
                item.SubItems.Add(row["Province"].ToString());

                listViewClient.Items.Add(item);
            }
        }
 private void ClientMaintenance_Load(object sender, EventArgs e)
 {
     dsClient.Tables.Add(dtClient);
     dsClient = UtilityDB.GetDataSetClients(dsClient, dtClient);
 }