Usa una HyperLinkColumn
e poi grazie ad una analisi della querystringcodice:<asp:HyperLinkColumn Text="Elimina Retta" Target="_self" DataNavigateUrlField="idretta" DataNavigateUrlFormatString="edit_retta.aspx?idretta={0}&cancella=ok" HeaderText="Elimina" NavigateUrl="edit_retta.aspx"></asp:HyperLinkColumn>
esegui questo codice
sempre meglio di quel obsloeto asp3codice:Sub Cancella() '# Connessione al database Dim connectionstring As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=" & Server.MapPath("villa.mdb") Dim conndel As New OleDbConnection(connectionstring) Dim sqldel As String = "delete from patologie where idretta=" & Request.QueryString("idretta") Dim DelCmd As New OleDbCommand(sqldel, conndel) '# Provo ad eseguire l'eliminazione della retta Try conndel.open() DelCmd.ExecuteNonquery() conndel.close() Catch exc As exception Response.Write(sqldel) End Try '# refresho il datagrid e mostro i dati a video Dim sql2 As String = "select * from patologie" Dim dbname2 As String = "villa.mdb" Dim aM As New aspnet() Dim ricerca = aM.search(sql2, dbname2) Dim storage2 As DataSet = aM.report DataGrid1.DataSource = storage2 DataGrid1.DataBind()![]()

Rispondi quotando