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();