i got error when alias name is used for a column in SqlDataSource (asp.net)

Question

0.00/5 (No votes)

See more:

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

XML

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

Posted 22-Aug-13 11:03am

surendra4u

Add a Solution

2 solutions

Solution 2

Hear PAID_DATE as DATE

XML

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

Posted 22-Aug-13 12:22pm

surendra4u

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maarten Kools · Accepted Answer · 2013-08-22T11:05:00

Solution 1

You haven't specified a PropertyName[^] on the ControlParameter.

Posted 22-Aug-13 11:05am

Maarten Kools

Comments

surendra4u 22-Aug-13 17:09pm

sorry, I didn't get you, can explain please

Maarten Kools 22-Aug-13 17:16pm

The ControlParameter class takes a property value from the Control (specified by ControlID property) and uses it as the named parameter (as specified by the Name property) for a SqlDataSource. However, the ControlParameter cannot guess what property value to get from the Control; it could be Value, or SelectedValue or maybe Text. Though there are some defaults (as explained by the documentation), judging from the error you get, it doesn't have a clue what property to use. So you'll need to specify that using the PropertyName property. Also see the example in the documentation page I linked to.

surendra4u 22-Aug-13 18:20pm

Finally i got the code (use this in coloumns tag)
<columns> <asp:BoundField ApplyFormatInEditMode="True" DataField="PAID_DATE"
HeaderText="DATE" SortExpression="PAID_DATE" />