Hi, I use a datagrid with a delete command. I create a validation on
the delete command and i have a problem: the confirmation message is
supposes to appear each time I do this command but it appear just
sometimes. Is anyone can tell me how to get this message everytime I
use this command ?
thanks
this is my code in the aspx.vb :
Private Sub DataGrid1_ItemD ataBound(ByVal sender As Object, ByVal e As
System.Web.UI.W ebControls.Data GridItemEventAr gs) Handles
DataGrid1.ItemD ataBound
If (e.Item.ItemTyp e = ListItemType.It em) Then
Dim control As WebControl
For Each control In e.Item.Controls
If CType(e.Item.Co ntrols(4).Contr ols(0),
LinkButton).Com mandName = "Delete" Then
CType(e.Item.Co ntrols(4).Contr ols(0),
WebControl).Att ributes.Add("on click", "test()")
End If
Next
End If
End Sub
Private Sub DataGrid1_Delet eCommand(ByVal source As Object, ByVal e As
System.Web.UI.W ebControls.Data GridCommandEven tArgs) Handles
DataGrid1.Delet eCommand
cnn.Open()
Dim Sql As String
Dim matrans As OdbcTransaction = cnn.BeginTransa ction
Dim cmd As New OdbcCommand
DataGrid1.EditI temIndex = e.Item.ItemInde x
Sql = "Delete from composition where fiberid=" &
e.Item.Cells(0) .Text & "and tuileid=1"
DataGrid1.EditI temIndex = -1
cmd.Connection = cnn
cmd.Transaction = matrans
Try
cmd.CommandType = CommandType.Tex t
cmd.CommandText = Sql
cmd.ExecuteNonQ uery()
matrans.Commit( )
Catch ex As Exception
Response.Write( DataGrid1.DataK eyField)
Response.Write( ex.Message())
Finally
cnn.Close()
ActualiserListe ()
End Try
End Sub
.. This is what i put in apx:
<script language="JavaS cript" />
<!--
function test()
{
if (window.confirm ("Do you want to delete?"))
{
}
else
{
event.returnVal ue = false;
}
}
//-->
</SCRIPT>
<form id="Form1" method="post" runat="server">
<table width="1136" border="2">
<TR><td>
<asp:datagrid id="DataGrid1" runat="server" Width="560px"
AutoGenerateCol umns="False" Height="106px">
<Columns>
<asp:BoundColum n Visible="False" DataField="fibe rid" ReadOnly="True"
HeaderText="Num fibre"></asp:BoundColumn >
<asp:TemplateCo lumn HeaderText="Fib re">
<ItemTemplate >
<asp:Label id=lblfibredg runat="server" Text='<%#
Container.DataI tem("namefiber" ) %>'>
</asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st id="lstdg" runat="server"> </asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:BoundColum n DataField="pour centage"
HeaderText="Pou rcentage"></asp:BoundColumn >
<asp:EditComman dColumn ButtonType="Lin kButton" UpdateText="Enr egistrer
modification" HeaderText="Mod ifier la ligne"
CancelText="Ann uler" EditText="Modif ier"></asp:EditCommand Column>
<asp:ButtonColu mn Text="Supprimer " HeaderText="Sup primer la ligne"
CommandName="De lete"></asp:ButtonColum n>
</Columns>
</asp:datagrid></td></tr>
</table>
</form>
