新手求解!!!!!!!!!!!!!!!!!

Question

<%int logID = loginusers.u_id;%>          <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:table_message_OA_DBConnectionString %>"
              SelectCommand="SELECT * FROM message where id=@id">
            <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="id" Type="Int32"/>
            </SelectParameters>
          </asp:SqlDataSource>
我想把logID传给@id
得怎么写呀?
新手求解

Answer 1

<SelectParameters> 
          <asp:ControlParameter   ControlID= "TextBox1"   Name= "id"   PropertyName= "Text "   /> 
</SelectParameters> 
SqlDataSource1.SelectParameters[ ""].DefaultValue   = TextBox1.Text ; 

Answer 2

ControlID= "TextBox1" Name= "id" PropertyName= "Text " 这个是控件吧?那要是变量呢???????

Answer 3

顶如梦大大，加个SelectParameters参数就行了

Answer 4

SqlDataSource1.SelectParameters[ ""].DefaultValue = TextBox1.Text ;asp里不认这个

Answer 5

导入它SqlDataSource类，比如：<%@ Import Namespace="System.Collections.Generic" %>