public string GetProductType(string aProductType) { string temp = string.Empty; List <DataRow> procudtList = (from DataRow row in ConstValue.ProductInfoTable().Rows where row["CODE"].ToString().Equals(aProductType) select row).ToList(); if (procudtList.Count > 0) { temp = procudtList[0]["CODE_NAME"].ToString(); } return(temp); }