有关使用带有返回功能的sql语言的问题 [英] a question about using sql language with a back function

问题描述

我写了一个带有功能的sql语句，但是它没有运行，该语句如下所示:

 <   asp:SqlDataSource     ID   ="     runat   =" 服务器" 
                                                              ConnectionString   ="  <％ $ ConnectionStrings:pw_ManagementConnectionString ％> " 
 
                                                              SelectCommand   =" 从PFM_ACC_BO中选择PAB_NAME，PAB_ID，其中PAB_USER_ID = <％ #GetUserID()％> " <  >  

GetUserID()是一个后退功能

 受保护的  int  GetUserID()
    {
        返回( int )会话["  UserID"];
    } 

我不知道问题出在哪里.sql语句不起作用并出现错误.
我需要一些帮助.非常感谢您的帮助.对不起，我的英语不好

解决方案

ConnectionStrings:pw_ManagementConnectionString ％> " SelectCommand =" 从PFM_ACC_BO中选择PAB_NAME，PAB_ID，其中PAB_USER_ID = <％ #GetUserID()％> " < >

GetUserID()是一个后退功能

 受保护的  int  GetUserID()
    {
        返回( int )会话["  UserID"];
    } 

我不知道问题出在哪里.sql语句不起作用并出现错误.
我需要一些帮助.非常感谢您的帮助.对不起，我的英语不好

检查您是否在以下字段中获得了适当的价值:

会话[" ]; 

您确定它应该是<%#GetUserID()%>而不是<%=GetUserID()%>吗?

只是一个想法！

-MRB

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

<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

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

解决方案

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

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

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

Session["UserID"];

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

Just a thought!

-MRB

这篇关于有关使用带有返回功能的sql语言的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！