怎样才能从asp.net中汲取这个商店处理器 [英] how can impliment this store processer from asp.net

问题描述

 声明  @ day   int  
  set   @ day  =  2  
 
 声明  @ days   varchar （ 8000 ）
  set   @ days  = '  [1]' 
   -   声明Pivot的最终列名 
 声明  @ columnsday   NVARCHAR （MAX）
  set   @ columnsday  = '  isnull（cast（[1] as varchar（10）），''''）为[1]' 
  WHILE （ @ day < =  31 ）
 < span class =code-keyword> BEGIN  
  set   @ days  =  @ days  + ' ，' + quotename （ convert （ varchar ， @ day ） ）
  set   @ columnsday  =  @ columnsday  + ' ，ISNULL（强制转换（' + quotename（ convert （ varchar ， @ day ））+ '  as varchar（10）），''''as' + quotename（ convert （ varchar ， @ day ））
  set   @ day  =  @ day  +  1  
   -    print @days  
  END  
   -    print @天 
   -    print @columnsday  
 
  DECLARE   @ query   varchar （ 8000 ）
  set   @ query  = < SP class =code-string>'  SELECT StudentCurrId，StudentCode，Stuname，' +  @ columnsday  + ' 来自
（SELECT tbl_StudentAttendanceDetails.StuAttendId，tbl_StudentAttendanceDetails.StudentCurrId，
 StudentCode， upper（First_Name +''''+ Middle_Name +''''+ Last_Name）as Stuname，
 day（StudentAttendanceDate）as day，Stuattend FROM tbl_StudentAttendanceDetails 
 inner join 
 tbl_StudentAttendanceMaster 
上tbl_StudentAttendanceDetails.StuAttendId = tbl_StudentAttendanceMaster.StuAttendId 
内加入tbl_Student_Current 
上tbl_StudentAttendanceDetails.StudentCurrId = tbl_Student_Current.StuCurrentId 
内上tbl_Student_Current.StudentId = StudentAdmission.StudentId 
其中tbl_StudentAttendanceMaster.SessionId加入StudentAdmission = 18' ++ ' 和
 tbl_StudentAttendanceMaster.ClassId = 54' ++ ' 和tbl_StudentAttendanceMaster .StreamId = 0' ++ '  
）AS SourceTable 
 
 pivot（
 MAX（Stuattend）
 for day in（' +  @ days  + ' ）
）p' 
 
  print （'  pivoted report'）
  exec （ @ query ）

解决方案

如果你想要要学习如何处理ASP.NET中的Store过程，请仔细阅读下面的内容。



1. 如何：执行使用不返回值的存储过程 [ ^ ]

2. 在ASP中使用存储过程。 NET [ ^ ]

declare @day  int
   set @day = 2

   declare @days varchar(8000)
   set @days = '[1]'
   -- Declare final column names for Pivot
   Declare @columnsday NVARCHAR(MAX)
   set @columnsday = 'isnull(cast([1] as varchar(10)),'''') as [1]'
   WHILE (@day <= 31)
   BEGIN
       set @days = @days + ', ' + quotename(convert(varchar, @day))
       set @columnsday = @columnsday + ',ISNULL(cast(' + quotename(convert(varchar, @day)) + ' as varchar(10)) ,'''') as '+ quotename(convert(varchar, @day))
      set @day  = @day + 1
       --print @days
   END
   --print @days
   --print @columnsday

   DECLARE @query varchar(8000)
   set @query = 'SELECT StudentCurrId,StudentCode,Stuname,' + @columnsday  + 'from
     (SELECT tbl_StudentAttendanceDetails.StuAttendId,tbl_StudentAttendanceDetails.StudentCurrId,
     StudentCode,upper(First_Name + '' '' + Middle_Name + '' '' + Last_Name) as Stuname,
     day(StudentAttendanceDate) as day,Stuattend FROM tbl_StudentAttendanceDetails
     inner join
     tbl_StudentAttendanceMaster
     on tbl_StudentAttendanceDetails.StuAttendId=tbl_StudentAttendanceMaster.StuAttendId
   inner join tbl_Student_Current
   on tbl_StudentAttendanceDetails.StudentCurrId=tbl_Student_Current.StuCurrentId
   inner join StudentAdmission on tbl_Student_Current.StudentId=StudentAdmission.StudentId
       where tbl_StudentAttendanceMaster.SessionId=18'++' and
         tbl_StudentAttendanceMaster.ClassId=54'++' and tbl_StudentAttendanceMaster.StreamId=0'++'
         ) AS SourceTable

      pivot (
            MAX(Stuattend)
               for day in (' + @days +')
             )p'

 print('pivoted report')
exec(@query)

解决方案

If you want to learn how to deal with Store procedures in ASP.NET, then go through the below.

1. How to: Execute a Stored Procedure that Returns No Value[^]
2. Using Stored Procedures with ASP.NET[^]

这篇关于怎样才能从asp.net中汲取这个商店处理器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！