-
Notifications
You must be signed in to change notification settings - Fork 1
/
Default.aspx
115 lines (111 loc) · 6.43 KB
/
Default.aspx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
<%@ Page Language="VB" AutoEventWireup="true" CodeBehind="Default.aspx.vb" Inherits="Test.Default" %>
<%@ Register Assembly="DevExpress.Web.v24.2, Version=24.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web" TagPrefix="dx" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>How to emulate ASPxGridView command button functionality</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:AccessDataSource ID="dataSource" runat="server" DataFile="~\App_Data\nwind.mdb"
OnDeleting="dataSource_Modifying" OnInserting="dataSource_Modifying" OnUpdating="dataSource_Modifying"
SelectCommand="SELECT * FROM [Customers]" DeleteCommand="DELETE FROM [Customers] WHERE [CustomerID] = ?"
InsertCommand="INSERT INTO [Customers] ([CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
UpdateCommand="UPDATE [Customers] SET [CompanyName] = ?, [ContactName] = ?, [City] = ?, [Region] = ?, [Country] = ? WHERE [CustomerID] = ?">
<DeleteParameters>
<asp:Parameter Name="CustomerID" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="CompanyName" Type="String" />
<asp:Parameter Name="ContactName" Type="String" />
<asp:Parameter Name="City" Type="String" />
<asp:Parameter Name="Region" Type="String" />
<asp:Parameter Name="Country" Type="String" />
</UpdateParameters>
</asp:AccessDataSource>
<dx:ASPxComboBox ID="cmbxEditForm" runat="server" ValueType="System.String" OnSelectedIndexChanged="cmbxEditForm_SelectedIndexChanged" AutoPostBack="true"
SelectedIndex="0">
<Items>
<dx:ListEditItem Value="Inline" />
<dx:ListEditItem Value="EditForm" />
<dx:ListEditItem Value="EditFormAndDisplayRow" />
<dx:ListEditItem Value="PopupEditForm" />
</Items>
</dx:ASPxComboBox>
<dx:ASPxGridView ID="grid" runat="server" DataSourceID="dataSource" KeyFieldName="CustomerID" ClientInstanceName="grid" Width="700px" Theme="Office365">
<Columns>
<dx:GridViewCommandColumn>
</dx:GridViewCommandColumn>
<dx:GridViewDataColumn Caption="Commands">
<DataItemTemplate>
<table>
<tr>
<td>
<dx:ASPxButton ID="btnNew" runat="server" Text="New" AutoPostBack="false">
<ClientSideEvents Click="function() { grid.AddNewRow(); }" />
</dx:ASPxButton>
</td>
<td>
<dx:ASPxButton ID="btnEdit" runat="server" Text="Edit" AutoPostBack="false" OnInit="btnEdit_Init">
</dx:ASPxButton>
</td>
<td>
<dx:ASPxButton ID="btnDelete" runat="server" Text="Delete" AutoPostBack="false" OnInit="btnDelete_Init">
</dx:ASPxButton>
</td>
</tr>
</table>
</DataItemTemplate>
<EditItemTemplate>
<table>
<tr>
<td>
<dx:ASPxButton ID="btnUpdate" runat="server" Text="Update" AutoPostBack="false">
<ClientSideEvents Click="function() { grid.UpdateEdit(); }" />
</dx:ASPxButton>
</td>
<td>
<dx:ASPxButton ID="btnCancel" runat="server" Text="Cancel" AutoPostBack="false">
<ClientSideEvents Click="function() { grid.CancelEdit(); }" />
</dx:ASPxButton>
</td>
</tr>
</table>
</EditItemTemplate>
<EditFormSettings Visible="false" />
</dx:GridViewDataColumn>
<dx:GridViewDataColumn FieldName="ContactName" />
<dx:GridViewDataColumn FieldName="CompanyName" />
<dx:GridViewDataColumn FieldName="City" />
<dx:GridViewDataColumn FieldName="Region"/>
<dx:GridViewDataColumn FieldName="Country" />
</Columns>
<SettingsPopup>
<EditForm Width="666px" />
</SettingsPopup>
<Templates>
<EditForm>
<dx:ASPxGridViewTemplateReplacement ID="Editors" ReplacementType="EditFormEditors" runat="server" />
<table>
<tr>
<td style="width: 100%" />
<td>
<dx:ASPxButton ID="btnUpdate" runat="server" Text="Update" AutoPostBack="false">
<ClientSideEvents Click="function() { grid.UpdateEdit(); }" />
</dx:ASPxButton>
</td>
<td>
<dx:ASPxButton ID="btnCancel" runat="server" Text="Cancel" AutoPostBack="false">
<ClientSideEvents Click="function() { grid.CancelEdit(); }" />
</dx:ASPxButton>
</td>
</tr>
</table>
</EditForm>
</Templates>
</dx:ASPxGridView>
</div>
</form>
</body>
</html>