private void UpdateParentDesc()
{
Part Part = new Part(DataList.EpicConn);
PartListDataSet PartList = new PartListDataSet();
string WhereClause = "PartNum = '" + parent_txt.Text + "'";
int pagesize = 1;
bool morePages;
PartList = Part.GetList(WhereClause, pagesize, 0, out morePages);
DataList.EpicClose();
parentdesc_txt.Text = PartList.Tables[0].Rows[0]["PartDescription"].ToString();
Part = null;
PartList.Dispose();
PartList = null;
}