private void customerDataGrid_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
//Method 1 - by qurey to sort
try
{
sqlAccess sqlcustomerlist = new sqlAccess();
_desc = (!_desc);
_customerlist = sqlcustomerlist.RetrievalCustomerList((customerDataGrid.Columns[e.ColumnIndex].DataPropertyName != null)? customerDataGrid.Columns[e.ColumnIndex].DataPropertyName : sqlAccess.CUSTOMERID, _desc);// argu sortitem, argu
customerDataGrid.DataSource = _customerlist.Getcustomerlist();
}
catch
{
MessageBox.Show("[Error] SQL access issue!");
}
//Method 2 - by
//_desc = (!_desc);
//try
//{
// customerDataGrid.Sort(customerDataGrid.Columns[1], (_desc == true) ? ListSortDirection.Descending : ListSortDirection.Ascending);
//}
//catch
//{
// MessageBox.Show("Oops, something worng!");
//}
}
private void updatathedatagrid(object sender, EventArgs e)
{
try
{
sqlAccess sqlcustomerlist = new sqlAccess();
_customerlist = sqlcustomerlist.SearchRecord(sqlAccess.MEMBERCARD, _membercardnumber);
this.CustomerdataGridView.AutoGenerateColumns = false;
this.CustomerdataGridView.DataSource = _customerlist.Getcustomerlist();
}
catch
{
MessageBox.Show("[Error] SQL access issue!");
}
}
protected void updatathedatagrid(object sender, EventArgs e)
{
try
{
sqlAccess sqlcustomerlist = new sqlAccess();
_customerlist = sqlcustomerlist.RetrievalCustomerList();
this.customerDataGrid.AutoGenerateColumns = false;
customerDataGrid.DataSource = _customerlist.Getcustomerlist();
}
catch
{
MessageBox.Show("[Error] SQL access issue!");
}
}
private void searchtextBox_TextChanged(object sender, EventArgs e)
{
sqlAccess sqlfindcustomer = new sqlAccess();
try
{
_customerlist = sqlfindcustomer.SearchRecord(searchcomboBox.Text, searchtextBox.Text);
customerDataGrid.DataSource = _customerlist.Getcustomerlist();
}
catch
{
MessageBox.Show("SQL data access fail!");
}
}
