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; }