private void SearchBtn_Click(object sender, EventArgs e)
{
Part Part = new Part(DataList.EpicConn);
PartListDataSet PartList = new PartListDataSet();
string WhereClause = PartNo() + Desc() + OfType() + Activity() + OnHold() + NonStock() + TrackLots() + SortBy();
int pageSize;
if (Properties.Settings.Default.allresults)
pageSize = 0;
else
pageSize = Properties.Settings.Default.linelimit;
bool morePages;
PartList = Part.GetList(WhereClause, pageSize, 0, out morePages);
DataList.EpicClose();
SearchResultGrid.AutoGenerateColumns = false;
SearchResultGrid.DataSource = PartList.Tables[0];
if (PartList.Tables[0].Rows.Count < 1)
SearchResultGrid.DataSource = "";
}