当别名用于SqlDataSource（asp.net）中的列时，我收到错误 [英] i got error when alias name is used for a column in SqlDataSource (asp.net)

问题描述

如何为列使用别名，在使用不带别名的列时工作正常

错误：找不到名称的字段或属性在选定的数据源上

 <  < span class =code-leadattribute> asp：SqlDataSource     ID   =  MONTHLYPAY    runat   =  server  
   
                                   ConnectionString   =   <％ $ ConnectionStrings：STUDENTConnectionString ％>   
   
   
   
                                           SelectCommand   = 从MONTHLY_PAY_INFO AS B，STUDENT_CONTACTS AS中选择​​A.STU_ID作为ID，FIRST_NAME，B.PAY_TYPE，PAID_AMMOUNT，PAID_DATE A B.STU_SNO = A.SNO AND B.STU_ID = @Sstsno ORDER BY PAID_DATE desc >  
 <   SelectParameters  >  
 <   asp：ControlParameter    名称  =  Sstsno    ControlID   =  search   类型  = 字符串    /  >  
 <   / SelectParameters  >  
 <   / asp：SqlDataSource  >  

解决方案

ConnectionStrings：STUDENTConnectionString ％>



SelectCommand = 选择A.STU_ID作为ID，FIRST_NAME，B.PAY_TYPE，PAID_AMMOUNT，PAID_DATE来自MONTHLY_PAY_INFO AS B，STUDENT_CONTACTS作为A其中B.STU_SNO = A.SNO和B.STU_ID = @Sstsno ORDER BY PAID_DATE desc >
< SelectParameters >
< < span class =code-leadattribute> asp：ControlParameter 名称 = Sstsno ControlID = 搜索 类型 = 字符串 / >
< / SelectParameters >
< / asp：SqlDataSource >

听听PAID_DATE为DATE

 <   asp：GridView     ID   =   GridView1    runat   =  server    AutoGenerateColumns   =  False  
   
                 DataSourceID  < span class =code-keyword> =  SqlDataSource1 >  
 <  列 >  
 <   asp ：BoundField     ApplyFormatInEditMode   =  True    DataField   =  PAID_DATE  
   
                                 HeaderText   =  DATE    SortExpression   =  PAID_DATE     /  >  
 <   /列 >  
 <   / asp：GridView  > ;  
 <   asp：SqlDataSource     ID   =  SqlDataSource1    runat   =  server  
   
                 ConnectionString   = < span class =code-keyword> <％ 

ConnectionStrings：STUDENTConnectionString ％>

SelectCommand = SELECT [PAID_DATE] FROM [MONTHLY_PAY_INFO] >
< / asp：SqlDataSource >

how can i use alias names for columns, working fine when using without alias for columns
ERROR: A field or property with the name was not found on the selected data source

<asp:SqlDataSource ID="MONTHLYPAY" runat="server"

                ConnectionString="<%$ ConnectionStrings:STUDENTConnectionString %>"



                    SelectCommand="Select  A.STU_ID as ID,  FIRST_NAME ,  B.PAY_TYPE ,  PAID_AMMOUNT ,  PAID_DATE  from MONTHLY_PAY_INFO AS B ,STUDENT_CONTACTS AS A Where B.STU_SNO = A.SNO AND B.STU_ID  = @Sstsno ORDER BY PAID_DATE desc">
                    <SelectParameters>
            <asp:ControlParameter Name="Sstsno" ControlID="search" Type="String" />
        </SelectParameters>
            </asp:SqlDataSource>

解决方案

ConnectionStrings:STUDENTConnectionString %>" SelectCommand="Select A.STU_ID as ID, FIRST_NAME , B.PAY_TYPE , PAID_AMMOUNT , PAID_DATE from MONTHLY_PAY_INFO AS B ,STUDENT_CONTACTS AS A Where B.STU_SNO = A.SNO AND B.STU_ID = @Sstsno ORDER BY PAID_DATE desc"> <SelectParameters> <asp:ControlParameter Name="Sstsno" ControlID="search" Type="String" /> </SelectParameters> </asp:SqlDataSource>

Hear PAID_DATE as DATE

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

       DataSourceID="SqlDataSource1">
       <Columns>
           <asp:BoundField ApplyFormatInEditMode="True" DataField="PAID_DATE"

               HeaderText="DATE" SortExpression="PAID_DATE" />
       </Columns>
   </asp:GridView>
   <asp:SqlDataSource ID="SqlDataSource1" runat="server"

       ConnectionString="<%

ConnectionStrings:STUDENTConnectionString %>" SelectCommand="SELECT [PAID_DATE] FROM [MONTHLY_PAY_INFO]"> </asp:SqlDataSource>

这篇关于当别名用于SqlDataSource（asp.net）中的列时，我收到错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！