-
Notifications
You must be signed in to change notification settings - Fork 0
/
cust_list.aspx
64 lines (55 loc) · 3.86 KB
/
cust_list.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
<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/Site1.Master" CodeBehind="cust_list.aspx.cs" Inherits="authwebpart.cust_list" %>
<asp:Content ID="Content1" ContentPlaceHolderID="custListID" runat="server">
<ol class="breadcrumb">
<li class="breadcrumb-item">
<asp:LinkButton ID="LinkButton6" runat="server" PostBackUrl="~/dashboard.aspx">Home</asp:LinkButton>
</li>
<li class="breadcrumb-item">
<asp:LinkButton ID="LinkButton2" runat="server" PostBackUrl="~/cust_list.aspx">List accounts</asp:LinkButton>
</li>
</ol>
<div class="container-fluid">
<div class="animated fadeIn">
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-header">
<i class="fa fa-align-justify"></i> Customer List
</div>
<div class="card-body">
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridView2_RowDataBound1" CssClass="table table-striped" DataSourceID="SqlDataSource1" >
<Columns>
<asp:TemplateField HeaderText="Id" >
<ItemTemplate>
<asp:LinkButton ID="LinkButton2" OnClick="LinkButton2_Click" Text='<%#Eval("c_id") %>' runat="server">LinkButton</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<a href="/view.aspx?c_id=<%#Eval("c_id") %>">
<asp:Label ID="Label2" runat="server" Text='<%# Bind("c_fname") %>'></asp:Label>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("c_mname") %>'></asp:Label>
<asp:Label ID="Label4" runat="server" Text='<%# Bind("c_lname") %>'></asp:Label>
</a>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="city" HeaderText="City" />
<asp:BoundField DataField="create_date" HeaderText="Date" DataFormatString="{0:d}" />
<asp:TemplateField HeaderText="Credit.(in Rs)">
</asp:TemplateField>
<asp:TemplateField HeaderText="Debit.(in Rs)">
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:v0scon %>" SelectCommand="SELECT [c_id], [c_fname], [c_mname], [c_lname], [city], [create_date] FROM [customer] WHERE ([isactive] = @isactive) ORDER BY [create_date] DESC ,[c_id] DESC">
<SelectParameters>
<asp:Parameter DefaultValue="True" Name="isactive" Type="Boolean" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</div>
</div>
</div>
</div>
</div>
</asp:Content>