public static DataTable GetPublication(string paramFilterValues)
{
DataAccess da = new DataAccess();
string sql = @"SELECT M_PUBLICATION.PUBLICATION_CODE,
M_PUBLICATION.PUBLICATION_DESC,
M_PUBLICATION.COUNTRY_CODE,
M_PUBLICATION.ESTABLISHED_DATE
FROM M_PUBLICATION";
if (paramFilterValues.Length > 0) { sql += " where publication_desc like '" + paramFilterValues + "%'"; }
DataTable dt = da.ExecuteDataSet(sql, CommandType.Text).Tables[0];
return dt;
}
