/providers/Tickets.aspx

 1<%@ Page Title="" Language="C#" MasterPageFile="~/providers/MasterPage.master" AutoEventWireup="true"
 2    CodeFile="Tickets.aspx.cs" Inherits="providers_Tickets" %>
 3
 4<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
 5</asp:Content>
 6<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
 7    <asp:GridView ID="GridView1" runat="server" 
 8        DataSourceID="SqlDataSource2" CellPadding="4" AutoGenerateColumns="False"
 9        ForeColor="#333333" GridLines="None" AllowPaging="True" 
10        AllowSorting="True" DataKeyNames="Id">
11        <RowStyle BackColor="#EFF3FB" />
12        <Columns>
13            <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id"
14                Visible="false" />
15            <asp:BoundField DataField="Number" HeaderText="Number" SortExpression="Number" />
16            <asp:BoundField DataField="Creator" HeaderText="Created By" SortExpression="Created By" />
17            <asp:BoundField DataField="Dept" HeaderText="Dept" ReadOnly="True" SortExpression="Dept" />
18            <asp:BoundField DataField="Group" HeaderText="Group" ReadOnly="True" SortExpression="Group" />
19            <asp:BoundField DataField="Project" HeaderText="Product" ReadOnly="True" SortExpression="Project" />
20            <asp:BoundField DataField="Team" HeaderText="Team" ReadOnly="True" SortExpression="Team" />
21            <asp:BoundField DataField="Priority" HeaderText="Priority" ReadOnly="True" SortExpression="Priority" />
22            <asp:BoundField DataField="Status" HeaderText="Status" ReadOnly="True" SortExpression="Status" />
23            <asp:BoundField DataField="Summary" HeaderText="Summary" SortExpression="Summary" />
24            <asp:BoundField DataField="StartDate" HeaderText="StartDate" SortExpression="StartDate" />
25            <asp:BoundField DataField="EndDate" HeaderText="EndDate" SortExpression="EndDate" />
26            <asp:HyperLinkField HeaderText="" 
27                                Text="Show" 
28                                DataNavigateUrlFields="Id"
29                                DataNavigateUrlFormatString="~/providers/Show.aspx?Id={0}" />
30        </Columns>
31        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
32        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
33        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
34        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
35        <EditRowStyle BackColor="#2461BF" />
36        <AlternatingRowStyle BackColor="White" />
37    </asp:GridView>
38    
39    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
40        ConnectionString="<%$ ConnectionStrings:aspnetdbConnectionString1 %>" 
41        SelectCommand="spGetTicketByProvider" SelectCommandType="StoredProcedure">
42        <SelectParameters>
43            <asp:SessionParameter Name="Provider" SessionField="UserId"  />
44        </SelectParameters>
45    </asp:SqlDataSource>
46
47</asp:Content>