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
|
<%@ Page Language="C#" MaintainScrollPositionOnPostback="true" %>
<%@ Register TagPrefix="smartDataSource" Assembly="Adillis.SmartDBForms" Namespace="Adillis.SmartDBForms.DataSource" %>
<%@ Register TagPrefix="smartDBforms" Assembly="Adillis.SmartDBForms" Namespace="Adillis.SmartDBForms" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server"><title>smartDBforms.NET DEMO - Region Form</title></head>
<body>
<form id="form1" runat="server">
<h3>Region form</h3>
<!-- Message area -->
<smartDBforms:OperationStatus ID="OperationStatus1" runat="server" ControlIDToHandle="RegionsView" Font-Names="Verdana" Font-Size="11px" Width="383px" >
</smartDBforms:OperationStatus>
<!-- SmartDBView for Regions -->
<smartDBforms:SmartDBView DefaultMode="ReadOnly" ID="RegionsView" runat="server" DataSourceID="RegionsDataSource" Width="383px" >
<Content>
<!-- SmartDBControls-->
<smartDBforms:SmartDBControl Field="RegionID" ID="ctrlRegionID" runat="server" /><br />
<smartDBforms:SmartDBControl Field="RegionDescription" ID="ctrlRegionDescription" runat="server" /><br />
<!-- Command buttons -->
<asp:Button ID="btnEdit" runat="server" CausesValidation="False" CommandName="Edit" Enabled="<%# Container.IsReadOnlyMode %>" Text="Edit" UseSubmitBehavior="False" Visible="<%# Container.IsReadOnlyMode %>" />
<asp:Button ID="btnUpdate1" runat="server" CausesValidation="True" CommandName="Update" Enabled="<%# Container.IsEditMode %>" Text="Update" UseSubmitBehavior="False" Visible="<%# Container.IsEditMode %>" />
<asp:Button ID="btnInsert" runat="server" CausesValidation="True" CommandName="Insert" Enabled="<%# Container.IsInsertMode %>" Text="Insert" UseSubmitBehavior="False" Visible="<%# Container.IsInsertMode %>" />
<asp:Button ID="btnCancel" runat="server" CausesValidation="False" CommandName="Cancel" Enabled="<%# Container.IsNotDefaultMode%>" Text="Cancel" UseSubmitBehavior="False" Visible="<%# Container.IsNotDefaultMode%>" />
<asp:Button ID="btnDelete" runat="server" CausesValidation="False" CommandName="Delete" Enabled="<%# Container.IsReadOnlyOrEditMode %>" Text="Delete" UseSubmitBehavior="False" Visible="<%# Container.IsReadOnlyOrEditMode %>"
OnClientClick="if(!confirm('Are you sure?')) return false;"/>
<asp:Button ID="btnNew" runat="server" CausesValidation="False" CommandName="New" Enabled="<%# Container.IsReadOnlyOrEditMode %>" Text="New" UseSubmitBehavior="False" Visible="<%# Container.IsReadOnlyOrEditMode %>" />
</Content>
</smartDBforms:SmartDBView>
<br />
<smartDBforms:SmartPager ID="SmartPager1" runat="server" ControlIDToPage="RegionsView"
VisiblePageNumbers="5" Font-Size="12px"/>
<!-- SmartDataSource for Regions -->
<smartDataSource:SmartDataSource ID="RegionsDataSource" runat="server" CancelSelectOnNullParameter="False"
ConnectionString="<%$ ConnectionStrings:LocalSql.Northwind %>"
SelectCommand="SELECT RegionID, RegionDescription FROM Region WHERE (RegionID >= @RegionID)"
UpdateCommand="UPDATE Region SET [RegionDescription] = @RegionDescription WHERE [RegionID] = @original_RegionID"
InsertCommand="INSERT INTO Region( [RegionID], [RegionDescription] ) VALUES ( @RegionID, @RegionDescription )"
DeleteCommand="DELETE FROM Region WHERE [RegionID] = @original_RegionID"
ProviderName="<%$ ConnectionStrings:LocalSql.Northwind.ProviderName %>">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="1" Name="RegionID" QueryStringField="RegionID" Type="Int32" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="original_RegionID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="RegionID" Type="Int32" />
<asp:Parameter Name="RegionDescription" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="RegionDescription" Type="String" />
<asp:Parameter Name="original_RegionID" Type="Int32" />
</UpdateParameters>
</smartDataSource:SmartDataSource>
</form>
</body>
</html>
|