-
Notifications
You must be signed in to change notification settings - Fork 2
/
UpdateMembers.aspx
49 lines (47 loc) · 3.19 KB
/
UpdateMembers.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
<%@ Page Title="" Language="C#" MasterPageFile="~/mainMasterPage.master" AutoEventWireup="true" CodeFile="UpdateMembers.aspx.cs" Inherits="UpdateMembers" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<h2 style="background-color: #efefef">
Update Members</h2>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="mid"
DataSourceID="SqlDataSource1" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2">
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="mid" HeaderText="mid" ReadOnly="True" SortExpression="mid" />
<asp:BoundField DataField="mname" HeaderText="mname" ReadOnly="True" SortExpression="mname" />
<asp:BoundField DataField="djoin" HeaderText="djoin" ReadOnly="True" SortExpression="djoin" />
<asp:BoundField DataField="depositamt" HeaderText="depositamt" SortExpression="depositamt" />
<asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
<asp:BoundField DataField="occupation" HeaderText="occupation" SortExpression="occupation" />
</Columns>
<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#FFF1D4" />
<SortedAscendingHeaderStyle BackColor="#B95C30" />
<SortedDescendingCellStyle BackColor="#F1E5CE" />
<SortedDescendingHeaderStyle BackColor="#93451F" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DBUtilConnectionString2 %>"
DeleteCommand="DELETE FROM [members] WHERE [mid] = @mid" InsertCommand="INSERT INTO [members] ([mid], [mname], [depositamt], [djoin], [email], [occupation]) VALUES (@mid, @mname, @depositamt, @djoin, @email, @occupation)"
SelectCommand="SELECT * FROM [members]" UpdateCommand="UPDATE [members] SET [depositamt] = @depositamt, [email] = @email, [occupation] = @occupation WHERE [mid] = @mid">
<DeleteParameters>
<asp:Parameter Name="mid" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="depositamt" Type="Int32" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="occupation" Type="String" />
<asp:Parameter Name="mid" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="mid" Type="Int32" />
<asp:Parameter Name="mname" Type="String" />
<asp:Parameter Name="depositamt" Type="Int32" />
<asp:Parameter Name="djoin" Type="DateTime" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="occupation" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</asp:Content>