ตอนผมลบข้อมูลออกจาก gridview อยากให้มี msg เตือนก่อนลบครับ แนะนำทีครับ
คือ gridview ผมนั้นทำปุ่ม delete เป็น แบบในรูปครับCode (ASP) <asp:GridView ID="myGridView" runat="server" AutoGenerateColumns="False" DataKeyNames="part_id"
OnRowEditing="modEditCommand" OnRowCancelingEdit="modCancelCommand" OnRowDeleting="modDeleteCommand"
OnRowUpdating="modUpdateCommand" CellPadding="4" ForeColor="#333333">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<Columns>
<asp:TemplateField ControlStyle-Width="90px" HeaderStyle-Font-Size="Larger" HeaderText="ID">
<ItemTemplate>
<asp:Label ID="lblpart_id" runat="server" Font-Size="9pt" Text='<%# DataBinder.Eval(Container, "DataItem.part_id") %>'></asp:Label>
</ItemTemplate>
<ControlStyle Width="90px" />
<HeaderStyle Font-Size="Larger" />
</asp:TemplateField>
<asp:TemplateField ControlStyle-Width="90px" HeaderStyle-Font-Size="Larger" HeaderText="Part">
<ItemTemplate>
<asp:Label ID="lblpart_name" runat="server" Font-Size="9pt" Text='<%# DataBinder.Eval(Container, "DataItem.part_name") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtEditpart_name" Font-Size="9pt" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.part_name") %>'></asp:TextBox>
</EditItemTemplate>
<ControlStyle Width="90px" />
<HeaderStyle Font-Size="Larger" />
</asp:TemplateField>
<asp:TemplateField ControlStyle-Width="90px" HeaderStyle-Font-Size="Larger" HeaderText="Product">
<ItemTemplate>
<asp:Label ID="lblProduct_Name" runat="server" Font-Size="9pt" Text='<%# DataBinder.Eval(Container, "DataItem.Product_Name") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtEditProduct_Name" Font-Size="9pt" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Product_Name") %>'></asp:TextBox>
</EditItemTemplate>
<ControlStyle Width="90px" />
<HeaderStyle Font-Size="Larger" />
</asp:TemplateField>
<asp:TemplateField ControlStyle-Width="90px" HeaderStyle-Font-Size="Larger" HeaderText="DCM">
<ItemTemplate>
<asp:Label ID="lblDCM" runat="server" Font-Size="9pt" Text='<%# DataBinder.Eval(Container, "DataItem.DCM") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtEditDCM" Font-Size="9pt" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.DCM") %>'></asp:TextBox>
</EditItemTemplate>
<ControlStyle Width="40px" />
<HeaderStyle Font-Size="Larger" />
</asp:TemplateField>
<asp:TemplateField ControlStyle-Width="90px" HeaderStyle-Font-Size="Larger" HeaderText="Status">
<ItemTemplate>
<asp:Label ID="lblPart_Status" runat="server" Font-Size="9pt" Text='<%# DataBinder.Eval(Container, "DataItem.Part_Status") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtEditPart_Status" Font-Size="9pt" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Part_Status") %>'></asp:TextBox>
</EditItemTemplate>
<ControlStyle Width="110px" />
<HeaderStyle Font-Size="Larger" />
</asp:TemplateField>
<asp:TemplateField ControlStyle-Width="90px" HeaderStyle-Font-Size="Larger" HeaderText="Eval">
<ItemTemplate>
<asp:Label ID="lblEval_Name" runat="server" Font-Size="9pt" Text='<%# DataBinder.Eval(Container, "DataItem.Eval_Name") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtEditEval_Name" Font-Size="9pt" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Eval_Name") %>'></asp:TextBox>
</EditItemTemplate>
<ControlStyle Width="90px" />
<HeaderStyle Font-Size="Larger" />
</asp:TemplateField>
<asp:TemplateField ControlStyle-Width="90px" HeaderStyle-Font-Size="Larger" HeaderText="Size">
<ItemTemplate>
<asp:Label ID="lblSize" runat="server" Font-Size="9pt" Text='<%# DataBinder.Eval(Container, "DataItem.Size") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtEditSize" Font-Size="9pt" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Size") %>'></asp:TextBox>
</EditItemTemplate>
<ControlStyle Width="40px" />
<HeaderStyle Font-Size="Larger" />
</asp:TemplateField>
<asp:TemplateField ControlStyle-Width="90px" HeaderStyle-Font-Size="Larger" HeaderText="Part Date">
<ItemTemplate>
<asp:Label ID="lblPart_Date" runat="server" Font-Size="9pt" Text='<%# DataBinder.Eval(Container, "DataItem.part_date") %>'></asp:Label>
</ItemTemplate>
<ControlStyle Width="80px" />
<HeaderStyle Font-Size="Larger" />
</asp:TemplateField>
<asp:CommandField ShowEditButton="True" CancelText="Cancel" DeleteText="Delete" EditText="Edit"
UpdateText="Update" HeaderText="Modify" />
<asp:CommandField ShowDeleteButton="True" HeaderText="Delete" />
</Columns>
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#999999" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
Code (VB.NET) Sub modDeleteCommand(ByVal sender As Object, ByVal e As GridViewDeleteEventArgs)
dbm.delete("t_part", "part_id='" + myGridView.DataKeys.Item(e.RowIndex).Value + "'")
myGridView.EditIndex = -1
BindData(ConString, "Delete")
End Sub
Tag .NET, Web (ASP.NET), VB.NET
ประวัติการแก้ไข
Date :
2011-05-03 09:40:29By :
sodamaxView :
1491Reply :
3
ตอนนี้ทำได้แล้วครับCode (ASP) <asp:TemplateField HeaderText="Select">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" OnClientClick='return confirm("Are you sure you want to delete this item?");'
CausesValidation="false" CommandName="Delete" >Delete </asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
Date :
2011-05-03 13:08:42By :
sodamax
เป็นประโยชน์อย่างยิ่ง ขอบคุณค่ะ สำหรับวิธีแก้
Date :
2012-01-06 14:51:51By :
นิว
Server 01
Load balance : Server 01
