gridview数据源来自存储过程

来源:互联网 发布:老年网络大学 编辑:程序博客网 时间:2024/06/05 13:34

gridview1数据源来自存储过程

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
                                ConnectionString="<%$ ConnectionStrings:ProjectMISConn %>"
  
                               
                                SelectCommand="usersInRole" SelectCommandType="StoredProcedure">
                                <SelectParameters>
                                    <asp:Parameter DefaultValue="'re1_cp'" Name="role" Type="String" />
                                </SelectParameters>
                            </asp:SqlDataSource>

存储过程usersInRole。

代码中调整参数     SqlDataSource1.SelectParameters["role"].DefaultValue = role.Text;
            GridView1.DataBind();