string fids = "";

            for (int i = 0; i < fieldIDs.Length; i++)            {                 if (!fieldIDs[i].Equals("")) { fids += "," + fieldIDs[i]; }            }            fids = (fids.Length > 1 ? fids.Substring(1) : "*");

string cmdText = @"SELECT ROW_NUMBER() OVER(ORDER BY UPLOADDT DESC) AS ROW_INDEX,

                                   " + fids + " FROM SURVEYINFO(NOLOCK)  WHERE 1=1";            if (!string.IsNullOrEmpty(where_clause) && where_clause != "")            {                 cmdText += " and " + where_clause;            }            if (!string.IsNullOrEmpty(orderby_clause) && orderby_clause != "")            {                 cmdText += " " + orderby_clause;            }                        int iStartPage = (iPageIndex * iPageSize) + 1;            int iEndPage = (iPageIndex * iPageSize) + iPageSize;            cmdText = string.Format(@"SELECT * FROM ({0}) T                                 WHERE T.ROW_INDEX BETWEEN {1} AND {2}", cmdText, iStartPage, iEndPage);

 

 

return SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, cmdText).Tables[0];