111,098
社区成员




<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:sper_lvyouConnectionString1 %>"
SelectCommand="
SELECT a.UserId,a.UserName, b.Password, b.Email, b.PasswordQuestion,b.PasswordAnswer, b.CreateDate
FROM dbo.aspnet_Users as a INNER JOIN
dbo.aspnet_Membership as b ON b.UserId = a.UserId
ORDER By
b.CreateDate desc" DeleteCommand="DeleteUser" OnDeleting="SqlDataSource1OnDeleting" DeleteCommandType="StoredProcedure">
<%--
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" AllowPaging="True" AllowSorting="True"
AutoGenerateDeleteButton="true" OnRowDeleting="GridView1OnRowDeleting">
<Columns>
<asp:BoundField DataField="UserId" HeaderText="UserId"
SortExpression="UserId" />
<asp:BoundField DataField="UserName" HeaderText="UserName"
SortExpression="UserName" />
<asp:BoundField DataField="Password" HeaderText="Password"
SortExpression="Password" />
<asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
<asp:BoundField DataField="PasswordQuestion" HeaderText="PasswordQuestion"
SortExpression="PasswordQuestion" />
<asp:BoundField DataField="PasswordAnswer" HeaderText="PasswordAnswer"
SortExpression="PasswordAnswer" />
<asp:BoundField DataField="CreateDate" HeaderText="CreateDate"
SortExpression="CreateDate" />
</Columns>
</asp:GridView>