Ciao a tutti. Vorrei poter eliminare dal db sql creato in App_data gli utenti che non devono più eseere utilizzati.
Ho creato una pagina con una GridView e come per i db Access ho inserito la riga di DeleteCommand ma non riesco ad eliminare le righe che mi servono, mi da sempre errori.
Qualcuno mi aiuta?
Allego lcodice...
Grazie mille...
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="test" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Gestione Utenti</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" AllowSorting="True">
<Columns>
<asp:CommandField ShowDeleteButton="True" />
<asp:BoundField DataField="ApplicationId" HeaderText="ApplicationId" ReadOnly="True"
SortExpression="ApplicationId" />
<asp:BoundField DataField="UserId" HeaderText="UserId" SortExpression="UserId" />
<asp:BoundField DataField="UserName" HeaderText="UserName" SortExpression="UserName" />
<asp:BoundField DataField="LoweredUserName" HeaderText="LoweredUserName" ReadOnly="True"
SortExpression="LoweredUserName" />
<asp:BoundField DataField="MobileAlias" HeaderText="MobileAlias" SortExpression="MobileAlias" />
<asp:CheckBoxField DataField="IsAnonymous" HeaderText="IsAnonymous" SortExpression="IsAnonymous" />
<asp:BoundField DataField="LastActivityDate" HeaderText="LastActivityDate" SortExpression="LastActivityDate" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString %>"
SelectCommand="SELECT [ApplicationId], [UserId], [UserName], [LoweredUserName], [MobileAlias], [IsAnonymous], [LastActivityDate] FROM [vw_aspnet_Users]"
DeleteCommand="DELETE [vw_aspnet_Users] WHERE [UserId]=[UserId]">
<DeleteParameters>
<asp:Parameter Name="[UserId]" Type="Char"/>
</DeleteParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
Rispondi quotando
