SQL stored procedure, which returns a DataTable or DataSet based on multiple criteria queries

No nonsense, First direct code

First the SQL section (I add a @zx here as a judgment, generally do not need this parameter):

ALTER Proc [dbo].[Proc_boss_show]@StrIndex varchar( -),--number of start bars@EndIndex varchar( -),--End Bar Number@StrWhere  varchar(Max),@zx int --execution interval 1 execution top N 2 display all data asbegin     Declare  @strSqlstr varchar( -)          if(@zx=1)     begin         Set @strSqlstr='SELECT * FROM (select top'+@EndIndex         Set @strSqlstr+='row_number () over (order by pickup time Desc) as xx,* from View_boss_show where 1=1'+@StrWhere         Set @strSqlstr+=') as xx where xx>'+@StrIndex    End     if(@zx=2)    begin       Set @strSqlstr='SELECT * from View_boss_show where 1=1'+@StrWhere    EndPrint @strSqlstrexec(@strSqlstr)

ASP. NET code (received directly in DataTable):

NULL ;             Try             {                = dbhelper.getdatatable ("proc_view_show1391", para);            }             catch  (Exception ex)            //throw new Exception (ex. ToString ());            }

SQL stored procedure, which returns a DataTable or DataSet based on multiple criteria queries