forked from johndavedecano/tanghalangpasigenyo
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Default2.aspx
62 lines (58 loc) · 4.02 KB
/
Default2.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
<%@ Page Title="Tanghalang Pasigueño" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="EmployeeId" DataSourceID="SqlDataSource1"
EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="EmployeeId" HeaderText="Employee Id" ReadOnly="True"
SortExpression="EmployeeId" />
<asp:BoundField DataField="EmployeeFname" HeaderText="Employee Firstname"
SortExpression="EmployeeFname" />
<asp:BoundField DataField="EmployeeMname" HeaderText="Employee Middlename"
SortExpression="EmployeeMname" />
<asp:BoundField DataField="EmployeeLname" HeaderText="Employee Lastname"
SortExpression="EmployeeLname" />
<asp:BoundField DataField="EmployeeJob" HeaderText="Employee Job"
SortExpression="EmployeeJob" />
<asp:BoundField DataField="EmployeeAddress" HeaderText="Employee Address"
SortExpression="EmployeeAddress" />
<asp:BoundField DataField="EmployeesContactNo" HeaderText="Employees Contact No."
SortExpression="EmployeesContactNo" />
<asp:BoundField DataField="VenueId" HeaderText="Service Id"
SortExpression="VenueId" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:YnaresDatabaseConnectionString1 %>"
DeleteCommand="DELETE FROM [EmployeeTbl] WHERE [EmployeeId] = @EmployeeId"
InsertCommand="INSERT INTO [EmployeeTbl] ([EmployeeId], [EmployeeFname], [EmployeeMname], [EmployeeLname], [EmployeeJob], [EmployeeAddress], [EmployeesContactNo], [VenueId]) VALUES (@EmployeeId, @EmployeeFname, @EmployeeMname, @EmployeeLname, @EmployeeJob, @EmployeeAddress, @EmployeesContactNo, @VenueId)"
ProviderName="<%$ ConnectionStrings:YnaresDatabaseConnectionString1.ProviderName %>"
SelectCommand="SELECT [EmployeeId], [EmployeeFname], [EmployeeMname], [EmployeeLname], [EmployeeJob], [EmployeeAddress], [EmployeesContactNo], [VenueId] FROM [EmployeeTbl]"
UpdateCommand="UPDATE [EmployeeTbl] SET [EmployeeFname] = @EmployeeFname, [EmployeeMname] = @EmployeeMname, [EmployeeLname] = @EmployeeLname, [EmployeeJob] = @EmployeeJob, [EmployeeAddress] = @EmployeeAddress, [EmployeesContactNo] = @EmployeesContactNo, [VenueId] = @VenueId WHERE [EmployeeId] = @EmployeeId">
<DeleteParameters>
<asp:Parameter Name="EmployeeId" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="EmployeeId" Type="Int32" />
<asp:Parameter Name="EmployeeFname" Type="String" />
<asp:Parameter Name="EmployeeMname" Type="String" />
<asp:Parameter Name="EmployeeLname" Type="String" />
<asp:Parameter Name="EmployeeJob" Type="String" />
<asp:Parameter Name="EmployeeAddress" Type="String" />
<asp:Parameter Name="EmployeesContactNo" Type="String" />
<asp:Parameter Name="VenueId" Type="Int32" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="EmployeeFname" Type="String" />
<asp:Parameter Name="EmployeeMname" Type="String" />
<asp:Parameter Name="EmployeeLname" Type="String" />
<asp:Parameter Name="EmployeeJob" Type="String" />
<asp:Parameter Name="EmployeeAddress" Type="String" />
<asp:Parameter Name="EmployeesContactNo" Type="String" />
<asp:Parameter Name="VenueId" Type="Int32" />
<asp:Parameter Name="EmployeeId" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</asp:Content>