> 
- Home Page
- > Script C#
- > Script C# Web Controls
- > Datagrid Conferma
Datagrid Conferma - << VERSIONE VB.NET >>
Inserire la conferma di cancellazione per gli elementi di un Datagrid
<%@ Page language="c#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<HTML>
<script language="c#" runat="server">
private void Page_Load(System.Object sender, System.EventArgs e)
{
if (!IsPostBack)
{
OleDbConnection dbConn;
OleDbDataAdapter myAdapter;
string sqlCmd;
string strConn;
DataSet oDataSet = new DataSet();
strConn =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + Server.MapPath("database/utenti.mdb") + ";" +
"Persist Security Info=False";
sqlCmd =
"SELECT " +
" nome, " +
" cognome, " +
" email " +
" FROM utenti";
dbConn = new OleDbConnection(strConn);
myAdapter = new OleDbDataAdapter(sqlCmd, dbConn);
myAdapter.Fill(oDataSet, "utenti");
myDatagrid.DataSource = oDataSet.Tables["utenti"].DefaultView;
myDatagrid.DataBind();
}
}
protected void myDatagrid_OnItemDataBound(Object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Button c = (Button)e.Item.Cells[0].FindControl("btnElimina");
c.Attributes["onClick"] = "return(confirm('Confermi?'))";
}
}
protected void myDatagrid_OnDeleteCommand(Object source, DataGridCommandEventArgs e)
{
//qui andebbe inserito il codice per cancellare la riga
lbMessaggio.Text = "CANCELLAZIONE EFFETTUATA";
}
</script>
<body>
<form runat="server" ID="Form1">
<asp:datagrid id="myDatagrid" runat="server" OnItemDataBound="myDatagrid_OnItemDataBound" OnDeleteCommand="myDatagrid_OnDeleteCommand">
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:Button id="btnElimina" runat="server" CommandName="Delete" Text="Elimina"></asp:Button>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
<asp:Label id="lbMessaggio" runat="server"></asp:Label>
</form>
</body>
</HTML>
