private string Construct_whereClause()
{
string retval = null;
try
{
Vendor Vend = new Vendor(DataList.EpicConn);
bool morePages;
VendorListDataSet VendList = Vend.GetList("VendorID = '" + idnum_txt.Text + "'", 100, 0, out morePages);
VendorID = VendList.Tables[0].Rows[0]["VendorNum"].ToString();
if (idnum_txt.Text != null && idnum_txt.Text != "")
retval += "VendorNum = '" + VendorID + "'";
if (name_txt.Text != null && name_txt.Text != "")
retval += " Name >= '" + name_txt.Text + "'";
retval += " BY NAME";
}
catch { retval = " BY NAME"; }
return retval;
}