a question about using sql language with a back function

Question

4.00/5 (1 vote)

See more:

I write a sql sentence with a function in it.but it does not run.the sentence is as following:

XML

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
                                   ConnectionString="<%$ ConnectionStrings:pw_ManagementConnectionString %>"
                                   SelectCommand="SELECT PAB_NAME, PAB_ID FROM PFM_ACC_BO  WHERE PAB_USER_ID=<%#GetUserID()%>"></asp:SqlDataSource>

GetUserID() is a back function

C#

protected int GetUserID()
    {
        return (int)Session["UserID"];
    }

I do not know where is the problem.the sql sentence does not work and get a error.
I need some help.thank you very much for your help. sorry for my poor english

Posted 20-Apr-11 2:49am

hkpares

Updated 20-Apr-11 2:56am

v2

Add a Solution

Comments

Pr@teek B@h! 20-Apr-11 9:06am

What's the error that you are getting?

2 solutions

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)

Om Prakash Pant · Answer 1 · 2011-04-20T03:19:00

Solution 1

check if you are getting proper value in the following field:

MIDL

Session["UserID"];

Posted 20-Apr-11 3:19am

Om Prakash Pant

Comments

hkpares 20-Apr-11 9:36am

I just can not compile it.There is a compile error. and I have test that Session["UserID"] is right.
I think that the problem may lies in the sql syntax that I do not know.

Manfred Rudolf Bihy · Answer 2 · 2011-04-20T03:34:00

Solution 2

Are you sure it's supposed to be <%#GetUserID()%> rather than <%=GetUserID()%>?

Just a thought!

-MRB

Posted 20-Apr-11 3:34am

Manfred Rudolf Bihy

Comments

hkpares 20-Apr-11 10:29am

thank you very much!

Manfred Rudolf Bihy 20-Apr-11 11:07am

Did this solution solve you problem?
Then please accept my solution and cast a vote.
Thanks!