Solved

SQL IF ELSE Query not working in Gridview

Posted on 2009-06-29
13
684 Views
Last Modified: 2012-08-13
Greetings,  I have an IF ELSE SQL query to display in a Gridview.  Basically, there is a textbox that would pull a specific query to the Gridview.  this works fine.  In the event that the box is null, the query would pull into the gridview all rows with incident type "Deployer" and not in "Complete" status.  When I test the query in the Desgner (VB 2008), it runs correctly, no issue.  When I post the Web App, the Gridview is blank, unless you enter search criteria.  Makes no sense to me, and makes me wonder why the Designer has a query test tool when the test works but not the app.  Anyway, attached is my code.  Any help is greatly appreciated...I must also state that I'm not a developer and very new to SQL and ASP, so please forgive if my question is silly...Regards
Imports System.Data.SqlClient

Imports System.Net

Imports System.Xml.Serialization

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Deployer.aspx.vb" Inherits="Test" %>
 

<!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>Klingon Deployer</title>

    <style type="text/css">
 
 

        .style6

        {

            font-size: small;

            width: -300;

        }

        #LEOSTREAM

        {

            z-index: 1;

            left: 11px;

            top: 2359px;

            position: absolute;

        }

        #I1

        {

            position: relative;

        }

        .style8

        {

            width: 981px;

            height: 25px;

        }

        .style9

        {

            width: 991px;

            height: 25px;

        }

        .style12

        {

            height: 25px;

            width: 176px;

        }

        .style15

        {

            width: 154px;

            height: 25px;

        }

        .style19

        {

            font-size: large;

            font-weight: bold;

        }

        .style18

        {

            width: 155px;

        }

        #I2

        {

            position: relative;

        }

        .style22

        {

            width: 267px;

        }

        .style23

        {

            width: 188px;

        }

        .style24

        {

            width: 188px;

            font-weight: bold;

        }

        .style25

        {

            height: 25px;

            width: 174px;

            font-weight: bold;

            font-size: large;

        }

        .style29

        {

            height: 25px;

            width: 174px;

            font-weight: bold;

            font-size: x-large;

        }

        .style30

        {

            font-size: large;

        }

        .style31

        {

            width: 318px;

            height: 25px;

        }

        .style35

        {

            height: 25px;

            width: 174px;

        }

        .style36

        {

            font-size: small;

            width: 318px;

        }

        .style37

        {

            height: 25px;

            width: 425px;

        }

        .style39

        {

            width: 162px;

            height: 25px;

        }

        .style40

        {

            width: 130px;

            height: 25px;

        }

        .style42

        {

            width: 178px;

            height: 25px;

        }

        .style44

        {

            height: 25px;

            width: 174px;

            font-weight: bold;

            color: #FF3300;

        }

        .style45

        {

            width: 230px;

        }

        .style46

        {

            width: 230px;

            height: 25px;

        }

        </style>

</head>

<body>

    <form id="form1" runat="server">

    <div>

    

        <asp:Panel ID="Panel1" runat="server">

            <img alt="" src="win2000l.gif" style="width: 60px; height: 55px" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

            <br />

            <asp:Label ID="Title" runat="server" CssClass="style6" Font-Bold="True" 

                Font-Size="Large" style="z-index: 1; left: 84px; top: 38px; position: absolute" 

                Text="Klingon BSR Workflow Tool - Deployer"></asp:Label>

            <br />

        </asp:Panel>

    

    </div>

    <asp:MultiView ID="MultiView1" runat="server" ActiveViewIndex="0" 

        EnableViewState="False">

        <asp:View ID="View1" runat="server">

            &nbsp;Search (SID, Last Name, EURC #):&nbsp;

            <asp:TextBox ID="INCSEARCH" runat="server"></asp:TextBox>

            &nbsp;

            <asp:Button ID="SEARCHBUTTON" runat="server" Text="Button" />

            <br />

            <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 

                AllowSorting="True" AutoGenerateColumns="False" BorderStyle="Solid" 

                CaptionAlign="Top" CssClass="style6" DataKeyNames="incidentId" 

                DataSourceID="SqlDataSource1" EmptyDataText="There are Open Incidents!" 

                EnableViewState="False" Font-Bold="True" HorizontalAlign="Left" PageSize="30">

                <RowStyle Font-Bold="True" Font-Size="X-Small" HorizontalAlign="Center" 

                    VerticalAlign="Middle" />

                <Columns>

                    <asp:TemplateField AccessibleHeaderText="Select" ShowHeader="False">

                        <ItemTemplate>

                            <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" 

                                CommandName="Select" onclick="GridView1_SelectedIndexChanged" Text="Select"></asp:LinkButton>

                        </ItemTemplate>

                    </asp:TemplateField>

                    <asp:BoundField DataField="incidentId" HeaderText="Incident ID" 

                        InsertVisible="False" ReadOnly="True" SortExpression="incidentId" />

                    <asp:BoundField DataField="createDate" DataFormatString="{0:MMM d, yyyy}" 

                        HeaderText="Submission Date" ReadOnly="True" SortExpression="createDate" />

                    <asp:BoundField DataField="status" HeaderText="Status" ReadOnly="True" 

                        SortExpression="status" />

                    <asp:BoundField DataField="eurcNumber" HeaderText="EURC Reference" 

                        ReadOnly="True" SortExpression="eurcNumber" />

                    <asp:BoundField DataField="incidentType" HeaderText="Incident Type" 

                        ReadOnly="True" SortExpression="incidentType" />

                    <asp:BoundField DataField="incidentDetailed" HeaderText="Incident Detailed" 

                        SortExpression="incidentDetailed" />

                    <asp:BoundField DataField="assignedSid" HeaderText="Assigned Tech" 

                        SortExpression="assignedSid" />

                    <asp:BoundField DataField="assignedLastName" HeaderText="Tech Last Name" 

                        SortExpression="assignedLastName" />

                    <asp:BoundField DataField="assignedFirstName" HeaderText="Tech First Name" 

                        SortExpression="assignedFirstName" />

                    <asp:BoundField DataField="affectedSid" HeaderText="Client SID" 

                        SortExpression="affectedSid" />

                    <asp:BoundField DataField="affectedLastName" HeaderText="Client Last Name" 

                        SortExpression="affectedLastName" />

                    <asp:BoundField DataField="affectedFirstName" HeaderText="Client First Name" 

                        SortExpression="affectedFirstName" />

                    <asp:BoundField DataField="building" HeaderText="Building Location" 

                        SortExpression="building" />

                    <asp:BoundField DataField="assignedemail" HeaderText="Tech E-Mail" 

                        SortExpression="assignedemail" />

                </Columns>

                <SelectedRowStyle HorizontalAlign="Left" VerticalAlign="Top" Wrap="False" />

                <HeaderStyle BackColor="#003399" Font-Bold="True" Font-Size="XX-Small" 

                    ForeColor="White" />

                <AlternatingRowStyle BackColor="White" />

            </asp:GridView>

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <b><span class="style30">

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            <br />

            </span></b>

        </asp:View>

        <asp:View ID="View3" runat="server">

            <asp:SqlDataSource ID="SqlDataSource3" runat="server" 

                ConnectionString="<%$ ConnectionStrings:VDIConnectionString %>" 

                

                

                

                SelectCommand="SELECT [incidentId], [eurcNumber], [status], [incidentType], [incidentDetailed], [quantity], [assignedSid], [assignedLastName], [assignedFirstName],[assignedemail], [affectedSid], [affectedLastName], [affectedFirstName], [building], [floor], [city], [state], [phone], [email], [alternateContact], [acPhone], [comments], [createDate] FROM [BVF_Metrics] WHERE ([incidentId] = @incidentId)">

                <SelectParameters>

                    <asp:ControlParameter ControlID="GridView1" Name="incidentId" 

                        PropertyName="SelectedValue" Type="Int32" />

                </SelectParameters>

            </asp:SqlDataSource>

            <asp:FormView ID="FormView1" runat="server" AllowPaging="True" 

                DataSourceID="SqlDataSource3">

                <EditItemTemplate>

                    incidentId:

                    <asp:Label ID="incidentIdLabel1" runat="server" 

                        Text='<%# Eval("incidentId") %>' />

                    <br />

                    eurcNumber:

                    <asp:TextBox ID="eurcNumberTextBox" runat="server" 

                        Text='<%# Bind("eurcNumber") %>' />

                    <br />

                    status:

                    <asp:TextBox ID="statusTextBox" runat="server" Text='<%# Bind("status") %>' />

                    <br />

                    incidentType:

                    <asp:TextBox ID="incidentTypeTextBox" runat="server" 

                        Text='<%# Bind("incidentType") %>' />

                    <br />

                    incidentDetailed:

                    <asp:TextBox ID="incidentDetailedTextBox" runat="server" 

                        Text='<%# Bind("incidentDetailed") %>' />

                    <br />

                    quantity:

                    <asp:TextBox ID="quantityTextBox" runat="server" 

                        Text='<%# Bind("quantity") %>' />

                    <br />

                    assignedSid:

                    <asp:TextBox ID="assignedSidTextBox" runat="server" 

                        Text='<%# Bind("assignedSid") %>' />

                    <br />

                    assignedLastName:

                    <asp:TextBox ID="assignedLastNameTextBox" runat="server" 

                        Text='<%# Bind("assignedLastName") %>' />

                    <br />

                    assignedFirstName:

                    <asp:TextBox ID="assignedFirstNameTextBox" runat="server" 

                        Text='<%# Bind("assignedFirstName") %>' />

                    <br />

                    affectedSid:

                    <asp:TextBox ID="affectedSidTextBox" runat="server" 

                        Text='<%# Bind("affectedSid") %>' />

                    <br />

                    affectedLastName:

                    <asp:TextBox ID="affectedLastNameTextBox" runat="server" 

                        Text='<%# Bind("affectedLastName") %>' />

                    <br />

                    affectedFirstName:

                    <asp:TextBox ID="affectedFirstNameTextBox" runat="server" 

                        Text='<%# Bind("affectedFirstName") %>' />

                    <br />

                    building:

                    <asp:TextBox ID="buildingTextBox" runat="server" 

                        Text='<%# Bind("building") %>' />

                    <br />

                    floor:

                    <asp:TextBox ID="floorTextBox" runat="server" Text='<%# Bind("floor") %>' />

                    <br />

                    city:

                    <asp:TextBox ID="cityTextBox" runat="server" Text='<%# Bind("city") %>' />

                    <br />

                    state:

                    <asp:TextBox ID="stateTextBox" runat="server" Text='<%# Bind("state") %>' />

                    <br />

                    phone:

                    <asp:TextBox ID="phoneTextBox" runat="server" Text='<%# Bind("phone") %>' />

                    <br />

                    email:

                    <asp:TextBox ID="emailTextBox" runat="server" Text='<%# Bind("email") %>' />

                    <br />

                    alternateContact:

                    <asp:TextBox ID="alternateContactTextBox" runat="server" 

                        Text='<%# Bind("alternateContact") %>' />

                    <br />

                    acPhone:

                    <asp:TextBox ID="acPhoneTextBox" runat="server" Text='<%# Bind("acPhone") %>' />

                    <br />

                    comments:

                    <asp:TextBox ID="commentsTextBox" runat="server" 

                        Text='<%# Bind("comments") %>' />

                    <br />

                    createDate:

                    <asp:TextBox ID="createDateTextBox" runat="server" 

                        Text='<%# Bind("createDate") %>' />

                    <br />

                    <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 

                        CommandName="Update" Text="Update" />

                    &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" 

                        CausesValidation="False" CommandName="Cancel" Text="Cancel" />

                </EditItemTemplate>

                <ItemTemplate>

                    <table class="style9" width="100">

                        <tr>

                            <td class="style29" nowrap="nowrap">

                                Incident Update</td>

                            <td class="style36">

                                &nbsp;</td>

                            <td class="style31" nowrap="nowrap">

                                &nbsp;</td>

                            <td class="style37" nowrap="nowrap">

                                <asp:Button ID="RETINC" runat="server" ForeColor="#009933" Height="30px" 

                                    style="margin-left: 0px" Text="Return to Incidents" Width="150px" 

                                    onclick="ret_inc" />

                            </td>

                        </tr>

                        <tr>

                            <td class="style25" nowrap="nowrap">

                                Incident ID:

                                <asp:Label ID="incid" runat="server" Text='<%# Eval("incidentId") %>'></asp:Label>

                            </td>

                            <td class="style31">

                                <b><span class="style30">EURC:

                                <asp:Label ID="EURC" runat="server" Text='<%# Eval("eurcNumber") %>'></asp:Label>

                                &nbsp;Quantity: </span>

                                <asp:TextBox ID="qbox" runat="server" Height="22px" Width="30px">1</asp:TextBox>

                                </b></td>

                            <td class="style31" nowrap="nowrap">

                                <b><span class="style30">Submission: </span></b><b><span class="style30">

                                <asp:Label ID="SUBDATE" runat="server" Text='<%# Eval("createDate") %>'></asp:Label>

                                </span></b>

                            </td>

                            <td class="style37">

                                <b><span class="style30">Status:&nbsp;

                                <asp:DropDownList ID="STATUSDDL" runat="server" 

                                    SelectedValue='<%# Eval("status") %>'>

                                    <asp:ListItem></asp:ListItem>

                                    <asp:ListItem>NEW</asp:ListItem>

                                    <asp:ListItem>IN PROGRESS</asp:ListItem>

                                    <asp:ListItem>PENDING</asp:ListItem>

                                    <asp:ListItem>COMPLETE</asp:ListItem>

                                    <asp:ListItem>REOPEN-IF</asp:ListItem>

                                </asp:DropDownList>

                                </span></b>

                            </td>

                        </tr>

                        <tr>

                            <td class="style35" nowrap="nowrap">

                                Type:

                                <asp:DropDownList ID="ITDDL" runat="server" 

                                    SelectedValue='<%# Eval("incidentType") %>'>

                                    <asp:ListItem></asp:ListItem>

                                    <asp:ListItem>BUILDER</asp:ListItem>

                                    <asp:ListItem>COORDINATOR</asp:ListItem>

                                    <asp:ListItem>DEPLOYER</asp:ListItem>

                                </asp:DropDownList>

                            </td>

                            <td class="style31" nowrap="nowrap">

                                Type Detailed:&nbsp;

                                <asp:DropDownList ID="IDDDL" runat="server" 

                                    SelectedValue='<%# Eval("incidentDetailed") %>'>

                                    <asp:ListItem></asp:ListItem>

                                    <asp:ListItem>BUILD VDI</asp:ListItem>

                                    <asp:ListItem>BUILD DESKTOP/LAPTOP</asp:ListItem>

                                    <asp:ListItem>INVENTORY MGMT</asp:ListItem>

                                    <asp:ListItem>LDR</asp:ListItem>

                                    <asp:ListItem>COORDINATE BUILD</asp:ListItem>

                                    <asp:ListItem>COORDINATE INSTALL</asp:ListItem>

                                    <asp:ListItem>COORDINATE PROJECT</asp:ListItem>

                                    <asp:ListItem>DEPLOY HW</asp:ListItem>

                                    <asp:ListItem>DEPLOY SW</asp:ListItem>

                                    <asp:ListItem>BLACKBERRY</asp:ListItem>

                                    <asp:ListItem>PRINTER</asp:ListItem>

                                    <asp:ListItem>PROFILE</asp:ListItem>

                                    <asp:ListItem>PURCHASE</asp:ListItem>

                                    <asp:ListItem>OTHER</asp:ListItem>

                                </asp:DropDownList>

                            </td>

                            <td class="style31" nowrap="nowrap">

                                Assigned SID:

                                <asp:TextBox ID="ATECH" runat="server" Height="21px" 

                                    Text='<%# Eval("assignedSid") %>' Width="77px"></asp:TextBox>

                                &nbsp;<asp:Button ID="Button1" runat="server" Height="21px" 

                                    onclick="change_assigned" Text="Get" Width="42px" />

                            </td>

                            <td class="style37">

                                <asp:TextBox ID="TFN" runat="server" Text='<%# Eval("assignedFirstName") %>'></asp:TextBox>

                                &nbsp;

                                <asp:TextBox ID="TLN" runat="server" Text='<%# Eval("assignedLastName") %>'></asp:TextBox>

                                &nbsp;<br />

                                <asp:TextBox ID="temail" runat="server" Text='<%# Eval("assignedemail") %>' 

                                    Width="262px"></asp:TextBox>

                            </td>

                        </tr>

                        <tr>

                            <td class="style35" nowrap="nowrap">

                                Client Info:&nbsp;

                                <asp:TextBox ID="CSID" runat="server" Height="21px" 

                                    Text='<%# Eval("affectedSid") %>' Width="77px"></asp:TextBox>

                            </td>

                            <td class="style31" nowrap="nowrap">

                                &nbsp;<asp:Button ID="getclient" runat="server" Height="21px" onclick="getclient" 

                                    Text="Get" Width="42px" />

                                &nbsp;

                                <asp:Label ID="CFN" runat="server" Text='<%# Eval("affectedFirstName") %>'></asp:Label>

                                &nbsp;

                                <asp:Label ID="CLN" runat="server" Text='<%# Eval("affectedLastName") %>'></asp:Label>

                            </td>

                            <td class="style31" nowrap="nowrap">

                                <asp:Label ID="BUILDING" runat="server" Text='<%# Eval("building") %>'></asp:Label>

                                &nbsp;

                                <asp:Label ID="FLOOR" runat="server" Text='<%# Eval("floor") %>'></asp:Label>

                            </td>

                            <td class="style37">

                                <asp:Label ID="CITY" runat="server" Text='<%# Eval("city") %>'></asp:Label>

                                ,

                                <asp:Label ID="STATE" runat="server" Text='<%# Eval("state") %>'></asp:Label>

                            </td>

                        </tr>

                        <tr valign="middle">

                            <td class="style35" nowrap="nowrap">

                                <asp:Label ID="PHONE" runat="server" Text='<%# Eval("phone") %>'></asp:Label>

                            </td>

                            <td class="style31">

                                <asp:Label ID="EMAIL" runat="server" Text='<%# Eval("email") %>'></asp:Label>

                            </td>

                            <td class="style31">

                                Alternate:

                                <asp:Label ID="ALTCONTACT" runat="server" 

                                    Text='<%# Eval("alternateContact") %>'></asp:Label>

                            </td>

                            <td class="style37">

                                Alt Phone:

                                <asp:Label ID="ACPHONE" runat="server" Text='<%# Eval("acPhone") %>'></asp:Label>

                            </td>

                        </tr>

                        <tr>

                            <td class="style35" nowrap="nowrap">

                                Build Type:</td>

                            <td class="style31" nowrap="nowrap">

                                <asp:Button ID="DEPLOYHW" runat="server" Height="30px" Text="Deploy Hardware" 

                                    Width="150px" onclick="DTBUILD_GO" />

                                &nbsp;<asp:Button ID="PROFVDI" runat="server" Height="30px" 

                                    onclick="VDIBUILD_GO" Text="Profile VDI DT/LT" Width="150px" />

                            </td>

                            <td class="style31">

                                <asp:Button ID="BLACKBERRY" runat="server" Height="30px" onclick="bb_form" 

                                    Text="Install Blackberry" Width="150px" />

                                &nbsp;<asp:Button ID="SOFTWARE" runat="server" Height="30px" onclick="COOR_SW" 

                                    Text="Install Software" Width="150px" />

                            </td>

                            <td class="style37">

                                &nbsp;</td>

                        </tr>

                        <tr>

                            <td class="style35" nowrap="nowrap">

                                Comments:</td>

                            <td class="style31">

                                <asp:TextBox ID="COMMENTS" runat="server" TextMode="MultiLine" Width="286px" 

                                    Text='<%# Eval("comments") %>'></asp:TextBox>

                            </td>

                            <td class="style31">

                                <asp:Button ID="ACKNOWLEDGE" runat="server" BorderColor="#FF3300" 

                                    BorderStyle="Inset" ForeColor="#FF3300" Height="30px" onclick="acknowledge" 

                                    Text="Acknowledge Incident" Width="150px" />

                                &nbsp;<asp:Button ID="IUIU" runat="server" BorderColor="#FF3300" BorderStyle="Inset" 

                                    ForeColor="Red" Height="30px" onclick="IUIU_Click" Text="Update Incident" 

                                    Width="150px" />

                            </td>

                            <td class="style37">

                                &nbsp;</td>

                        </tr>

                    </table>

                </ItemTemplate>

            </asp:FormView>

        </asp:View>

        <asp:View ID="View4" runat="server">

            <asp:Label ID="Label3" runat="server" Font-Bold="True" Font-Size="Large" 

                Text="Profile &amp; (Soft) Deploy VDI and Desktop/Laptop Form"></asp:Label>

            &nbsp;&nbsp;<asp:Label ID="emailOK" runat="server"></asp:Label><asp:Label 

                ID="tlfn" runat="server" Visible="False"></asp:Label>&nbsp;<asp:Label 

                ID="tlln" runat="server" Visible="False"></asp:Label><asp:Label 

                ID="TLEMAIL" runat="server" style="height: 22px" Visible="False"></asp:Label><br />

            <b>Hostname:</b>&nbsp;&nbsp;<asp:TextBox ID="vdisite" runat="server" Width="141px"></asp:TextBox>&nbsp;<b>IP 

            Address:</b>

            <asp:TextBox ID="vdisubsite" runat="server" Width="141px"></asp:TextBox>

            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:LinkButton ID="BACK" runat="server">Back to Incident Update</asp:LinkButton><br />

            <b>Name:</b>

            <asp:Label ID="CFN" runat="server"></asp:Label>

&nbsp;<asp:Label ID="CLN" runat="server"></asp:Label>&nbsp;<b>SID:</b>

            <asp:Label ID="VDICSID" runat="server"></asp:Label>

            &nbsp;<table class="style8">

                <tr>

                    <td class="style15" nowrap="nowrap">

                        VDI Profile Status:</td>

                    <td class="style15">

                        <asp:DropDownList ID="VDIPROFSTATDDL" runat="server">

                            <asp:ListItem></asp:ListItem>

                            <asp:ListItem>NEW</asp:ListItem>

                            <asp:ListItem>IN PROGRESS</asp:ListItem>

                            <asp:ListItem>PENDING</asp:ListItem>

                            <asp:ListItem>COMPLETE</asp:ListItem>

                            <asp:ListItem>LOB DESKTOP</asp:ListItem>

                        </asp:DropDownList>

                    </td>

                    <td class="style42">

                        VDI (Soft) Deploy Status:</td>

                    <td class="style12">

                        <asp:DropDownList ID="VDIDEPSTATDDL" runat="server">

                            <asp:ListItem></asp:ListItem>

                            <asp:ListItem>NEW</asp:ListItem>

                            <asp:ListItem>IN PROGRESS</asp:ListItem>

                            <asp:ListItem>PENDING</asp:ListItem>

                            <asp:ListItem>COMPLETE</asp:ListItem>

                            <asp:ListItem>LOB DESKTOP</asp:ListItem>

                        </asp:DropDownList>

                    </td>

                </tr>

                <tr>

                    <td class="style15" nowrap="nowrap">

                        Desktop/Laptop Profile Status:</td>

                    <td class="style15">

                        <asp:DropDownList ID="DTPROFSTATDDL" runat="server">

                            <asp:ListItem></asp:ListItem>

                            <asp:ListItem>NEW</asp:ListItem>

                            <asp:ListItem>IN PROGRESS</asp:ListItem>

                            <asp:ListItem>PENDING</asp:ListItem>

                            <asp:ListItem>LOB DESKTOP</asp:ListItem>

                            <asp:ListItem>COMPLETE</asp:ListItem>

                        </asp:DropDownList>

                    </td>

                    <td class="style42">

                        UAT Status:</td>

                    <td class="style12">

                        <asp:DropDownList ID="VDIUATSTATDDL" runat="server">

                            <asp:ListItem></asp:ListItem>

                            <asp:ListItem>NEW</asp:ListItem>

                            <asp:ListItem>IN PROGRESS</asp:ListItem>

                            <asp:ListItem>PENDING</asp:ListItem>

                            <asp:ListItem>COMPLETE</asp:ListItem>

                        </asp:DropDownList>

                    </td>

                </tr>

                <tr>

                    <td class="style15" nowrap="nowrap">

                        Initiate Client UAT:</td>

                    <td class="style15">

                        <asp:Button ID="CLIENTUAT" runat="server" Height="25px" Text="Client UAT" 

                            Width="141px" />

                    </td>

                    <td class="style42">

                        Deploy (Soft) VDI:</td>

                    <td class="style12">

                        <asp:Button ID="DEPVDISOFT" runat="server" Height="25px" Text="Deploy VDI" 

                            Width="141px" />

                    </td>

                </tr>

                <tr>

                    <td class="style15" nowrap="nowrap">

                        <asp:Label ID="rettouptxt" runat="server" ForeColor="Red" style="height: 22px" 

                            Text="Return to Incident Update:"></asp:Label>

                    </td>

                    <td class="style15">

                        <asp:Button ID="VDIINCUP" runat="server" ForeColor="Red" Height="25px" 

                            Text="Incident Update" Width="141px" />

                    </td>

                    <td class="style42">

                        <asp:Label ID="opencoortxt" runat="server" style="height: 22px" 

                            Text="Open New Incident:"></asp:Label>

                    </td>

                    <td class="style12">

                        <asp:Button ID="COORINC" runat="server" Height="25px" Text="New Incident" 

                            Width="141px" />

                    </td>

                </tr>

            </table>

            

            Client Application Information:<br />

            <br />

            <iframe ID="BVF" height="500" name="I1" 

                src="http://gcsweb.jpmorganchase.com/bvf/bysid.asp" width="100%">

            <p>

                Your browser does not support iframes.</p>

            </iframe>

            <br />

        </asp:View>

        <asp:View ID="View5" runat="server">

            <b><span class="style30">Deploy Hardware</span></b><span class="style19">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

            <asp:LinkButton ID="BACK1" runat="server" Font-Size="Medium">Back to Incident Update</asp:LinkButton>

            </span>

            <br />

            &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

            <br />

            <table class="style8">

                <tr>

                    <td class="style24" nowrap="nowrap" valign="middle">

                        Hardware (If Applicable):</td>

                    <td class="style45" nowrap="nowrap">

                        Type:

                        <asp:Label ID="DEPHWTYPE" runat="server"></asp:Label>

                    </td>

                    <td class="style18" nowrap="nowrap">

                        Model:

                        <asp:Label ID="DEPHWMODEL" runat="server"></asp:Label>

                    </td>

                    <td>

                        Location:&nbsp;<asp:Label ID="DEPHWLOC" runat="server"></asp:Label></td>

                </tr>

                <tr>

                    <td class="style23" nowrap="nowrap" valign="middle">

                        &nbsp;</td>

                    <td class="style45" nowrap="nowrap">

                        Rack:&nbsp;<asp:Label ID="DEPHWRACK" runat="server"></asp:Label></td>

                    <td class="style18" nowrap="nowrap">

                        Serial Number:</td>

                    <td>

                        <asp:Label ID="DEPHWSERIAL" runat="server"></asp:Label>

                    </td>

                </tr>

                <tr>

                    <td class="style35" nowrap="nowrap">

                        Client Info:&nbsp;

                        <asp:Label ID="DEPCSID" runat="server" Text='<%# Eval("affectedSid") %>'></asp:Label>

                    </td>

                    <td class="style46" nowrap="nowrap">

                        <asp:Label ID="DEPCFN" runat="server" Text='<%# Eval("affectedFirstName") %>'></asp:Label>

                        &nbsp;

                        <asp:Label ID="DEPCLN" runat="server" Text='<%# Eval("affectedLastName") %>'></asp:Label>

                    </td>

                    <td class="style31" nowrap="nowrap">

                        <asp:Label ID="DEPBUILDING" runat="server" Text='<%# Eval("building") %>'></asp:Label>

                        &nbsp;

                        <asp:Label ID="DEPFLOOR" runat="server" Text='<%# Eval("floor") %>'></asp:Label>

                    </td>

                    <td class="style37">

                        <asp:Label ID="DEPCITY" runat="server" Text='<%# Eval("city") %>'></asp:Label>

                        ,

                        <asp:Label ID="DEPSTATE" runat="server" Text='<%# Eval("state") %>'></asp:Label>

                    </td>

                </tr>

                <tr>

                    <td class="style35" nowrap="nowrap">

                        <asp:Label ID="DEPPHONE" runat="server" Text='<%# Eval("phone") %>'></asp:Label>

                    </td>

                    <td class="style46">

                        <asp:Label ID="DEPEMAIL" runat="server" Text='<%# Eval("email") %>'></asp:Label>

                    </td>

                    <td class="style31">

                        Alternate:

                        <asp:Label ID="DEPALTCONTACT" runat="server" 

                            Text='<%# Eval("alternateContact") %>'></asp:Label>

                    </td>

                    <td class="style37">

                        Alt Phone:

                        <asp:Label ID="DEPACPHONE" runat="server" Text='<%# Eval("acPhone") %>'></asp:Label>

                    </td>

                </tr>

                <tr>

                    <td class="style35" nowrap="nowrap">

                        VDI HW Deployment Status:</td>

                    <td class="style46">

                        <asp:DropDownList ID="VDIHWDEPSTATDDL" runat="server">

                            <asp:ListItem></asp:ListItem>

                            <asp:ListItem>NEW</asp:ListItem>

                            <asp:ListItem>IN PROGRESS</asp:ListItem>

                            <asp:ListItem>PENDING</asp:ListItem>

                            <asp:ListItem>COMPLETE</asp:ListItem>

                            <asp:ListItem>LOB DESKTOP</asp:ListItem>

                        </asp:DropDownList>

                    </td>

                    <td class="style31">

                        Desktop/Laptop Deployment Status:</td>

                    <td class="style37">

                        <asp:DropDownList ID="DTDEPSTATDDL" runat="server">

                            <asp:ListItem></asp:ListItem>

                            <asp:ListItem>NEW</asp:ListItem>

                            <asp:ListItem>IN PROGRESS</asp:ListItem>

                            <asp:ListItem>PENDING</asp:ListItem>

                            <asp:ListItem>COMPLETE</asp:ListItem>

                            <asp:ListItem>LOB DESKTOP</asp:ListItem>

                        </asp:DropDownList>

                    </td>

                </tr>

                <tr>

                    <td class="style40" nowrap="nowrap">

                        <asp:Label ID="rettouptxt1" runat="server" ForeColor="Red" style="height: 22px" 

                            Text="Return to Incident Update:"></asp:Label>

                    </td>

                    <td class="style46">

                        <asp:Button ID="IUDTLT" runat="server" ForeColor="Red" Height="25px" 

                            Text="Incident Update" Width="141px" />

                    </td>

                    <td class="style39">

                        <asp:Label ID="opencoortxt1" runat="server" style="height: 22px" 

                            Text="Open New Incident:"></asp:Label>

                    </td>

                    <td class="style12">

                        <asp:Button ID="COORINCDTLT" runat="server" Height="25px" Text="New Incident" 

                            Width="141px" />

                    </td>

                </tr>

            </table>

            <br />

        </asp:View>

        <asp:View ID="View6" runat="server">

            <br />

            <br />

        </asp:View>

        <asp:View ID="View7" runat="server">

            <span class="style19">New Incident&nbsp; </span>

            <asp:Label ID="oldatechsid" runat="server" Visible="False"></asp:Label>

            <br />

            <table style="width:100%;">

                <tr>

                    <td class="style23" nowrap="nowrap" valign="middle">

                        Incident ID:

                        <asp:Label ID="newinc" runat="server" Text='<%# Eval("incidentId") %>'></asp:Label>

                    </td>

                    <td class="style22" nowrap="nowrap">

                        Submission Date:

                        <asp:Label ID="newsub" runat="server" EnableViewState="False" 

                            Text='<%# Eval("createDate") %>'></asp:Label>

                        &nbsp;</td>

                    <td class="style18" nowrap="nowrap">

                        EURC :

                        <asp:Label ID="NEWEURC" runat="server" EnableViewState="False" 

                            Text='<%# Eval("eurcNumber") %>'></asp:Label>

                    </td>

                    <td>

                        Quantity:

                        <asp:TextBox ID="NEWQBOX" runat="server" Text='<%# Bind("quantity") %>' 

                            Width="52px"></asp:TextBox>

                        &nbsp;

                        <asp:LinkButton ID="BACK3" runat="server">Back to Incident Update</asp:LinkButton>

                    </td>

                </tr>

                <tr>

                    <td class="style23" nowrap="nowrap" valign="middle">

                        Status:

                        <asp:DropDownList ID="NEWSTATUSDDL" runat="server" 

                            onselectedindexchanged="INCIDENT_COMPLETE" 

                            SelectedValue='<%# Bind("status") %>' Width="139px">

                            <asp:ListItem></asp:ListItem>

                            <asp:ListItem>NEW</asp:ListItem>

                            <asp:ListItem>PENDING</asp:ListItem>

                            <asp:ListItem>IN PROGRESS</asp:ListItem>

                            <asp:ListItem>COMPLETE</asp:ListItem>

                            <asp:ListItem>REOPEN-IF</asp:ListItem>

                        </asp:DropDownList>

                    </td>

                    <td class="style22" nowrap="nowrap">

                        Assigned SID:

                        <asp:TextBox ID="NEWATECH" runat="server" Text='<%# Bind("assignedSid") %>' 

                            Width="92px"></asp:TextBox>

                        &nbsp;&nbsp;

                        <asp:Button ID="NEWGETSID" runat="server" Font-Size="X-Small" Height="21px" 

                            Text="Change" Width="55px" />

                    </td>

                    <td class="style18" nowrap="nowrap">

                        <asp:TextBox ID="NEWTFN" runat="server" Text='<%# Bind("assignedSid") %>' 

                            Width="92px"></asp:TextBox>

                    </td>

                    <td>

                        <asp:TextBox ID="NEWTLN" runat="server" Text='<%# Bind("assignedSid") %>' 

                            Width="92px"></asp:TextBox>

                        &nbsp;<asp:TextBox ID="NEWTEMAIL" runat="server" Text='<%# Bind("assignedSid") %>' 

                            Width="92px"></asp:TextBox></td>

                </tr>

                <tr>

                    <td class="style23" nowrap="nowrap" valign="middle">

                        Incident Type:</td>

                    <td class="style22" nowrap="nowrap">

                        <asp:DropDownList ID="NEWITDDL" runat="server" 

                            SelectedValue='<%# Bind("incidentType") %>'>

                            <asp:ListItem></asp:ListItem>

                            <asp:ListItem>BUILDER</asp:ListItem>

                            <asp:ListItem>COORDINATOR</asp:ListItem>

                            <asp:ListItem>DEPLOYER</asp:ListItem>

                        </asp:DropDownList>

                    </td>

                    <td class="style18" nowrap="nowrap">

                        Incident Detailed:</td>

                    <td>

                        <asp:DropDownList ID="NEWIDDDL" runat="server" 

                            SelectedValue='<%# Bind("incidentDetailed") %>'>

                            <asp:ListItem></asp:ListItem>

                            <asp:ListItem>BUILD VDI</asp:ListItem>

                            <asp:ListItem>BUILD DESKTOP/LAPTOP</asp:ListItem>

                            <asp:ListItem>INVENTORY MGMT</asp:ListItem>

                            <asp:ListItem>LDR</asp:ListItem>

                            <asp:ListItem>COORDINATE BUILD</asp:ListItem>

                            <asp:ListItem>COORDINATE INSTALL</asp:ListItem>

                            <asp:ListItem>COORDINATE PROJECT</asp:ListItem>

                            <asp:ListItem>DEPLOY HW</asp:ListItem>

                            <asp:ListItem>DEPLOY SW</asp:ListItem>

                            <asp:ListItem>BLACKBERRY</asp:ListItem>

                            <asp:ListItem>PRINTER</asp:ListItem>

                            <asp:ListItem>PROFILE</asp:ListItem>

                            <asp:ListItem>PURCHASE</asp:ListItem>

                            <asp:ListItem>OTHER</asp:ListItem>

                        </asp:DropDownList>

                    </td>

                </tr>

                <tr>

                    <td class="style24" nowrap="nowrap" valign="middle">

                        Client Information</td>

                    <td class="style22" nowrap="nowrap">

                        &nbsp;</td>

                    <td class="style18" nowrap="nowrap">

                        &nbsp;</td>

                    <td>

                        &nbsp;</td>

                </tr>

                <tr>

                    <td class="style23" nowrap="nowrap" valign="middle">

                        SID:

                        <asp:Label ID="NEWcsid" runat="server" Text='<%# Eval("affectedSid") %>'></asp:Label>

                    </td>

                    <td class="style22" nowrap="nowrap">

                        Name:

                        <asp:Label ID="NEWCFN" runat="server" Text='<%# Eval("affectedFirstName") %>'></asp:Label>

                        &nbsp;<asp:Label ID="NEWCLN" runat="server" Text='<%# Eval("affectedLastName") %>'></asp:Label></td>

                    <td class="style18" nowrap="nowrap">

                        Client Phone:</td>

                    <td>

                        <asp:Label ID="NEWPHONE" runat="server" Text='<%# Eval("phone") %>'></asp:Label>

                    </td>

                </tr>

                <tr>

                    <td class="style23" nowrap="nowrap" valign="middle">

                        Building Address:</td>

                    <td class="style22" nowrap="nowrap">

                        <asp:Label ID="NEWBUILDING" runat="server" Text='<%# Eval("building") %>'></asp:Label>

                    </td>

                    <td class="style18" nowrap="nowrap">

                        Floor:</td>

                    <td>

                        <asp:Label ID="NEWFLOOR" runat="server" Text='<%# Eval("floor") %>'></asp:Label>

                    </td>

                </tr>

                <tr>

                    <td class="style23" nowrap="nowrap" valign="middle">

                        Client E-Mail:</td>

                    <td class="style22" nowrap="nowrap">

                        <asp:Label ID="NEWEMAIL" runat="server" Text='<%# Eval("email") %>'></asp:Label>

                    </td>

                    <td class="style18" nowrap="nowrap">

                        City</td>

                    <td>

                        <asp:Label ID="NEWCITY" runat="server" Text='<%# Eval("city") %>'></asp:Label>

                    </td>

                </tr>

                <tr>

                    <td class="style23" nowrap="nowrap" valign="middle">

                        State:</td>

                    <td class="style22" nowrap="nowrap">

                        <asp:Label ID="NEWSTATE" runat="server" Text='<%# Eval("state") %>'></asp:Label>

                    </td>

                    <td class="style18" nowrap="nowrap">

                        Alternate Contact:</td>

                    <td>

                        <asp:Label ID="NEWALTCONTACT" runat="server" 

                            Text='<%# Eval("alternateContact") %>'></asp:Label>

                    </td>

                </tr>

                <tr>

                    <td class="style23" nowrap="nowrap" valign="middle">

                        Altternate Phone:</td>

                    <td class="style22" nowrap="nowrap">

                        <asp:Label ID="NEWACPHONE" runat="server" Text='<%# Eval("acPhone") %>'></asp:Label>

                    </td>

                    <td class="style18" nowrap="nowrap">

                        &nbsp;</td>

                    <td>

                        &nbsp;</td>

                </tr>

                <tr>

                    <td class="style24" nowrap="nowrap" valign="middle">

                        Hardware (If Applicable):</td>

                    <td class="style22" nowrap="nowrap">

                        Type:

                        <asp:TextBox ID="NEWHWTYPE" runat="server" Height="18px" Width="116px"></asp:TextBox>

                        &nbsp;&nbsp;&nbsp; </td>

                    <td class="style18" nowrap="nowrap">

                        Model:

                        <asp:TextBox ID="NEWHWMODEL" runat="server" Height="18px" Width="105px"></asp:TextBox>

                    </td>

                    <td>

                        Location:&nbsp;

                        <asp:TextBox ID="NEWHWLOC" runat="server" Height="18px" Width="105px"></asp:TextBox>

                    </td>

                </tr>

                <tr>

                    <td class="style23" nowrap="nowrap" valign="middle">

                        &nbsp;</td>

                    <td class="style22" nowrap="nowrap">

                        Rack:&nbsp;

                        <asp:TextBox ID="NEWHWRACK" runat="server" Height="18px" Width="105px"></asp:TextBox>

                    </td>

                    <td class="style18" nowrap="nowrap">

                        Serial Number:</td>

                    <td>

                        <asp:TextBox ID="NEWHWSERIAL" runat="server" Height="18px" Width="199px"></asp:TextBox>

                    </td>

                </tr>

                <tr>

                    <td class="style24" nowrap="nowrap" valign="middle">

                        Software (If Applicable):</td>

                    <td class="style22" nowrap="nowrap">

                        Name:

                        <asp:TextBox ID="NEWSWNAME" runat="server" Height="18px" Width="116px"></asp:TextBox>

                    </td>

                    <td class="style18" nowrap="nowrap">

                        Path:</td>

                    <td>

                        <asp:TextBox ID="NEWSWPATH" runat="server" Height="18px" Width="199px"></asp:TextBox>

                    </td>

                </tr>

                <tr>

                    <td class="style23" nowrap="nowrap" valign="middle">

                        Comments:</td>

                    <td class="style22" nowrap="nowrap">

                        <asp:TextBox ID="NEWCOMMENTS" runat="server" TextMode="MultiLine"></asp:TextBox>

                    </td>

                    <td class="style18" nowrap="nowrap">

                        <asp:Button ID="NEWINCBUTTON" runat="server" Height="25px" 

                            Text="Create Incident" Width="141px" />

                    </td>

                    <td>

                        <asp:Button ID="NEWBBINC" runat="server" Height="25px" 

                            Text="Create BB Incident" Width="141px" />

                    </td>

                </tr>

            </table>

            <br />

        </asp:View>

        <asp:View ID="View8" runat="server">

            &nbsp;<b><span class="style30">Incident Search Tool</span></b><br />

            Enter Klingon Incident ID, Client SID or Client Last Name below:<br />

            <br />

            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

            &nbsp;

            <asp:Button ID="Button2" runat="server" Text="Button" />

            <br />

            <br />

            <asp:GridView ID="GridView2" runat="server" AllowPaging="True" 

                AllowSorting="True" AutoGenerateColumns="False" BorderStyle="Solid" 

                CaptionAlign="Top" CssClass="style6" DataKeyNames="incidentId" 

                DataSourceID="SqlDataSource9" EmptyDataText="There are No Open Incidents!" 

                EnableViewState="False" Font-Bold="True" HorizontalAlign="Left">

                <RowStyle Font-Bold="True" Font-Size="X-Small" HorizontalAlign="Center" 

                    VerticalAlign="Middle" />

                <Columns>

                    <asp:TemplateField AccessibleHeaderText="Select" ShowHeader="False">

                        <ItemTemplate>

                            <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" 

                                CommandName="Select" onclick="GridView1_SelectedIndexChanged" Text="Select"></asp:LinkButton>

                        </ItemTemplate>

                    </asp:TemplateField>

                    <asp:BoundField DataField="incidentId" HeaderText="Incident ID" 

                        InsertVisible="False" ReadOnly="True" SortExpression="incidentId">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="createDate" DataFormatString="{0:MMM d, yyyy}" 

                        HeaderText="Submission Date" ReadOnly="True" SortExpression="createDate">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="status" HeaderText="Status" ReadOnly="True" 

                        SortExpression="status">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="eurcNumber" HeaderText="EURC Reference" 

                        ReadOnly="True" SortExpression="eurcNumber">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="incidentType" HeaderText="Incident Type" 

                        ReadOnly="True" SortExpression="incidentType">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="incidentDetailed" HeaderText="Incident Detailed" 

                        SortExpression="incidentDetailed">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="assignedSid" HeaderText="Assigned Tech" 

                        SortExpression="assignedSid">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="assignedLastName" HeaderText="Tech Last Name" 

                        SortExpression="assignedLastName">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="assignedFirstName" HeaderText="Tech First Name" 

                        SortExpression="assignedFirstName">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="affectedSid" HeaderText="Client SID" 

                        SortExpression="affectedSid">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="affectedLastName" HeaderText="Client Last Name" 

                        SortExpression="affectedLastName">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="affectedFirstName" HeaderText="Client First Name" 

                        SortExpression="affectedFirstName">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="building" HeaderText="Building Location" 

                        SortExpression="building">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                    <asp:BoundField DataField="assignedemail" HeaderText="Tech E-Mail" 

                        SortExpression="assignedemail">

                        <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                    </asp:BoundField>

                </Columns>

                <SelectedRowStyle HorizontalAlign="Left" VerticalAlign="Top" Wrap="False" />

                <HeaderStyle BackColor="#003399" Font-Bold="True" Font-Size="XX-Small" 

                    ForeColor="White" />

                <AlternatingRowStyle BackColor="White" />

            </asp:GridView>

            <br />

            <br />

        </asp:View>

        <asp:View ID="View9" runat="server">

            <asp:Label ID="Label4" runat="server" Font-Bold="True" Font-Size="Large" 

                Text="Install Software"></asp:Label>

            &nbsp;&nbsp;<asp:Label ID="emailOK1" runat="server"></asp:Label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

            <asp:LinkButton ID="BACK4" runat="server">Back to Incident Update</asp:LinkButton>

            <br />

            <table class="style9" width="100">

                <tr>

                    <td class="style35" nowrap="nowrap">

                        Client Info:&nbsp;

                        <asp:Label ID="SOFTCSID" runat="server" Text='<%# Eval("affectedSid") %>'></asp:Label>

                    </td>

                    <td class="style31" nowrap="nowrap">

                        <asp:Label ID="SOFTCFN" runat="server" Text='<%# Eval("affectedFirstName") %>'></asp:Label>

                        &nbsp;

                        <asp:Label ID="SOFTCLN" runat="server" Text='<%# Eval("affectedLastName") %>'></asp:Label>

                    </td>

                    <td class="style31" nowrap="nowrap">

                        <asp:Label ID="SOFTBUILDING" runat="server" Text='<%# Eval("building") %>'></asp:Label>

                        &nbsp;

                        <asp:Label ID="SOFTFLOOR" runat="server" Text='<%# Eval("floor") %>'></asp:Label>

                    </td>

                    <td class="style37">

                        <asp:Label ID="SOFTCITY" runat="server" Text='<%# Eval("city") %>'></asp:Label>

                        ,

                        <asp:Label ID="SOFTSTATE" runat="server" Text='<%# Eval("state") %>'></asp:Label>

                    </td>

                </tr>

                <tr valign="middle">

                    <td class="style35" nowrap="nowrap">

                        <asp:Label ID="SOFTPHONE" runat="server" Text='<%# Eval("phone") %>'></asp:Label>

                    </td>

                    <td class="style31">

                        <asp:Label ID="SOFTEMAIL" runat="server" Text='<%# Eval("email") %>'></asp:Label>

                    </td>

                    <td class="style31">

                        Alternate:

                        <asp:Label ID="SOFTALTCONTACT" runat="server" 

                            Text='<%# Eval("alternateContact") %>'></asp:Label>

                    </td>

                    <td class="style37">

                        Alt Phone:

                        <asp:Label ID="SOFTACPHONE" runat="server" Text='<%# Eval("acPhone") %>'></asp:Label>

                    </td>

                </tr>

                <tr>

                    <td class="style35" nowrap="nowrap">

                        Software Name:</td>

                    <td class="style31" nowrap="nowrap">

                        <asp:TextBox ID="SOFTNAME" runat="server" Width="255px"></asp:TextBox>

                    </td>

                    <td class="style31">

                        Path:

                        <asp:TextBox ID="SOFTPATH" runat="server" Width="280px"></asp:TextBox>

                    </td>

                    <td class="style37">

                        &nbsp;</td>

                </tr>

                <tr>

                    <td class="style44" nowrap="nowrap">

                        Must Update First!</td>

                    <td class="style31">

                        Update Incident:

                        <asp:Button ID="SOFTIU" runat="server" ForeColor="Red" Height="25px" 

                            Text="Incident Update" Width="141px" />

                    </td>

                    <td class="style31">

                        &nbsp;Send Install to Client:

                        <asp:Button ID="SOFINCIDENT" runat="server" Height="25px" 

                            Text="Send Client Install" Width="141px" CausesValidation="False" 

                            UseSubmitBehavior="False" />

                    </td>

                    <td class="style37">

                        &nbsp;</td>

                </tr>

            </table>

            &nbsp;

        </asp:View>

        <br />

        <asp:View ID="View10" runat="server">

            <asp:Label ID="Label5" runat="server" Font-Bold="True" Font-Size="Large" 

                Text="Install Blackberry"></asp:Label>

            &nbsp;&nbsp;<asp:Label ID="emailOK2" runat="server"></asp:Label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

            <asp:LinkButton ID="BACK5" runat="server">Back to Incident Update</asp:LinkButton>

            <br />

            <table class="style9" width="100">

                <tr>

                    <td class="style35" nowrap="nowrap">

                        Client Info:&nbsp;

                        <asp:Label ID="BBCSID" runat="server" Text='<%# Eval("affectedSid") %>'></asp:Label>

                    </td>

                    <td class="style31" nowrap="nowrap">

                        <asp:Label ID="BBCFN" runat="server" Text='<%# Eval("affectedFirstName") %>'></asp:Label>

                        &nbsp;

                        <asp:Label ID="BBCLN" runat="server" Text='<%# Eval("affectedLastName") %>'></asp:Label>

                    </td>

                    <td class="style31" nowrap="nowrap">

                        <asp:Label ID="BBBUILDING" runat="server" Text='<%# Eval("building") %>'></asp:Label>

                        &nbsp;

                        <asp:Label ID="BBFLOOR" runat="server" Text='<%# Eval("floor") %>'></asp:Label>

                    </td>

                    <td class="style37">

                        <asp:Label ID="BBCITY" runat="server" Text='<%# Eval("city") %>'></asp:Label>

                        ,

                        <asp:Label ID="BBSTATE" runat="server" Text='<%# Eval("state") %>'></asp:Label>

                    </td>

                </tr>

                <tr valign="middle">

                    <td class="style35" nowrap="nowrap">

                        <asp:Label ID="BBPHONE" runat="server" Text='<%# Eval("phone") %>'></asp:Label>

                    </td>

                    <td class="style31">

                        <asp:Label ID="BBEMAIL" runat="server" Text='<%# Eval("email") %>'></asp:Label>

                    </td>

                    <td class="style31">

                        Alternate:

                        <asp:Label ID="BBALTCONTACT" runat="server" 

                            Text='<%# Eval("alternateContact") %>'></asp:Label>

                    </td>

                    <td class="style37">

                        Alt Phone:

                        <asp:Label ID="BBACPHONE" runat="server" Text='<%# Eval("acPhone") %>'></asp:Label>

                    </td>

                </tr>

                <tr>

                    <td class="style35" nowrap="nowrap">

                        Scheduled Date:</td>

                    <td class="style31" nowrap="nowrap">

                        <asp:TextBox ID="BBCOMMENTS" runat="server" TextMode="MultiLine" Width="305px"></asp:TextBox>

                    </td>

                    <td class="style31">

                        &nbsp;</td>

                    <td class="style37">

                        &nbsp;</td>

                </tr>

                <tr>

                    <td class="style44" nowrap="nowrap">

                        Must Update First!</td>

                    <td class="style31">

                        Update Incident:

                        <asp:Button ID="BBIU" runat="server" ForeColor="Red" Height="25px" 

                            Text="Incident Update" Width="141px" />

                    </td>

                    <td class="style31">

                        &nbsp;</td>

                    <td class="style37">

                        &nbsp;</td>

                </tr>

            </table>

            <br />

        </asp:View>

    </asp:MultiView>

    <br />

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 

        ConnectionString="<%$ ConnectionStrings:VDIConnectionString %>" 

        

        

        

        

        SelectCommand="IF @INCSEARCH IS NULL

BEGIN

SELECT [incidentId], [createDate], [eurcNumber], [status], [incidentType], [incidentDetailed], [assignedSid], [assignedLastName], [assignedFirstName], [assignedemail],[affectedSid], [affectedLastName], [affectedFirstName], [building] FROM [BVF_Metrics] WHERE [incidentType] = @incidentType AND [status] NOT LIKE 'COMPLETE%'  ORDER BY [createDate]

END

ELSE

BEGIN

SELECT [incidentId], [createDate], [eurcNumber], [status], [incidentType], [incidentDetailed], [assignedSid], [assignedLastName], [assignedFirstName], [assignedemail],[affectedSid], [affectedLastName], [affectedFirstName], [building] FROM [BVF_Metrics] WHERE [affectedsid] = @affectedsid OR [affectedlastname]=@affectedlastname OR [eurcnumber]=@eurcnumber AND [status] NOT LIKE 'COMPLETE%'  ORDER BY [createDate]

END">

        <SelectParameters>

            <asp:ControlParameter ControlID="INCSEARCH" Name="incsearch" 

                PropertyName="Text" />

            <asp:Parameter DefaultValue="DEPLOYER" Name="incidentType" Type="String" />

            <asp:ControlParameter ControlID="INCSEARCH" Name="affectedsid" 

                PropertyName="Text" />

            <asp:ControlParameter ControlID="INCSEARCH" Name="affectedlastname" 

                PropertyName="Text" />

            <asp:ControlParameter ControlID="INCSEARCH" Name="eurcnumber" 

                PropertyName="Text" />

        </SelectParameters>

    </asp:SqlDataSource>

    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 

        ConnectionString="<%$ ConnectionStrings:VDIConnectionString %>" 

        DeleteCommand="DELETE FROM [BVF_Metrics] WHERE [incidentId] = @incidentId" 

        InsertCommand="INSERT INTO [BVF_Metrics] ([createDate], [eurcNumber], [status], [incidentType], [incidentDetailed], [quantity], [assignedSid], [assignedLastName], [assignedFirstName], [affectedSid], [affectedLastName], [affectedFirstName], [building], [floor], [city], [state], [phone], [email], [alternateContact], [acPhone], [buildSite], [buildSubsite], [clientPW], [sandsVerified], [equipVerified], [ldrSub], [appReportAttached], [clientSupplyPW], [deploySched], [uatSched], [uatStatus], [comments]) VALUES (@createDate, @eurcNumber, @status, @incidentType, @incidentDetailed, @quantity, @assignedSid, @assignedLastName, @assignedFirstName, @affectedSid, @affectedLastName, @affectedFirstName, @building, @floor, @city, @state, @phone, @email, @alternateContact, @acPhone, @buildSite, @buildSubsite, @clientPW, @sandsVerified, @equipVerified, @ldrSub, @appReportAttached, @clientSupplyPW, @deploySched, @uatSched, @uatStatus, @comments)" 

        SelectCommand="SELECT [incidentId], [createDate], [eurcNumber], [status], [incidentType], [incidentDetailed], [quantity], [assignedSid], [assignedEmail], [assignedLastName], [assignedFirstName], [affectedSid], [affectedLastName], [affectedFirstName], [building], [floor], [city], [state], [phone], [email], [alternateContact], [acPhone], [buildSite], [buildSubsite], [clientPW], [sandsVerified], [equipVerified], [ldrSub], [appReportAttached], [clientSupplyPW], [deploySched], [uatSched], [uatStatus], [comments] FROM [BVF_Metrics] WHERE ([incidentId] = @incidentId)" 

        

        

        

        UpdateCommand="UPDATE [BVF_Metrics] SET [createDate] = @createDate, [eurcNumber] = @eurcNumber, [status] = @status, [incidentType] = @incidentType, [incidentDetailed] = @incidentDetailed, [quantity] = @quantity, [assignedSid] = @assignedSid, [assignedLastName] = @assignedLastName, [assignedFirstName] = @assignedFirstName, [affectedSid] = @affectedSid, [affectedLastName] = @affectedLastName, [affectedFirstName] = @affectedFirstName, [building] = @building, [floor] = @floor, [city] = @city, [state] = @state, [phone] = @phone, [email] = @email, [alternateContact] = @alternateContact, [acPhone] = @acPhone, [buildSite] = @buildSite, [buildSubsite] = @buildSubsite, [clientPW] = @clientPW, [sandsVerified] = @sandsVerified, [equipVerified] = @equipVerified, [ldrSub] = @ldrSub, [appReportAttached] = @appReportAttached, [clientSupplyPW] = @clientSupplyPW, [deploySched] = @deploySched, [uatSched] = @uatSched, [uatStatus] = @uatStatus, [comments] = @comments WHERE [incidentId] = @incidentId">

        <SelectParameters>

            <asp:ControlParameter ControlID="GridView1" Name="incidentId" 

                PropertyName="SelectedValue" Type="Int32" />

        </SelectParameters>

        <DeleteParameters>

            <asp:Parameter Name="incidentId" Type="Int32" />

        </DeleteParameters>

        <UpdateParameters>

            <asp:Parameter Name="createDate" Type="String" />

            <asp:Parameter Name="eurcNumber" Type="String" />

            <asp:Parameter Name="status" Type="String" />

            <asp:Parameter Name="incidentType" Type="String" />

            <asp:Parameter Name="incidentDetailed" Type="String" />

            <asp:Parameter Name="quantity" Type="Int32" />

            <asp:Parameter Name="assignedSid" Type="String" />

            <asp:Parameter Name="assignedLastName" Type="String" />

            <asp:Parameter Name="assignedFirstName" Type="String" />

            <asp:Parameter Name="affectedSid" Type="String" />

            <asp:Parameter Name="affectedLastName" Type="String" />

            <asp:Parameter Name="affectedFirstName" Type="String" />

            <asp:Parameter Name="building" Type="String" />

            <asp:Parameter Name="floor" Type="String" />

            <asp:Parameter Name="city" Type="String" />

            <asp:Parameter Name="state" Type="String" />

            <asp:Parameter Name="phone" Type="String" />

            <asp:Parameter Name="email" Type="String" />

            <asp:Parameter Name="alternateContact" Type="String" />

            <asp:Parameter Name="acPhone" Type="String" />

            <asp:Parameter Name="buildSite" Type="String" />

            <asp:Parameter Name="buildSubsite" Type="String" />

            <asp:Parameter Name="clientPW" Type="String" />

            <asp:Parameter Name="sandsVerified" Type="String" />

            <asp:Parameter Name="equipVerified" Type="String" />

            <asp:Parameter Name="ldrSub" Type="String" />

            <asp:Parameter Name="appReportAttached" Type="String" />

            <asp:Parameter Name="clientSupplyPW" Type="String" />

            <asp:Parameter Name="deploySched" Type="String" />

            <asp:Parameter Name="uatSched" Type="String" />

            <asp:Parameter Name="uatStatus" Type="String" />

            <asp:Parameter Name="comments" Type="String" />

            <asp:Parameter Name="incidentId" Type="Int32" />

        </UpdateParameters>

        <InsertParameters>

            <asp:Parameter Name="createDate" Type="String" />

            <asp:Parameter Name="eurcNumber" Type="String" />

            <asp:Parameter Name="status" Type="String" />

            <asp:Parameter Name="incidentType" Type="String" />

            <asp:Parameter Name="incidentDetailed" Type="String" />

            <asp:Parameter Name="quantity" Type="Int32" />

            <asp:Parameter Name="assignedSid" Type="String" />

            <asp:Parameter Name="assignedLastName" Type="String" />

            <asp:Parameter Name="assignedFirstName" Type="String" />

            <asp:Parameter Name="affectedSid" Type="String" />

            <asp:Parameter Name="affectedLastName" Type="String" />

            <asp:Parameter Name="affectedFirstName" Type="String" />

            <asp:Parameter Name="building" Type="String" />

            <asp:Parameter Name="floor" Type="String" />

            <asp:Parameter Name="city" Type="String" />

            <asp:Parameter Name="state" Type="String" />

            <asp:Parameter Name="phone" Type="String" />

            <asp:Parameter Name="email" Type="String" />

            <asp:Parameter Name="alternateContact" Type="String" />

            <asp:Parameter Name="acPhone" Type="String" />

            <asp:Parameter Name="buildSite" Type="String" />

            <asp:Parameter Name="buildSubsite" Type="String" />

            <asp:Parameter Name="clientPW" Type="String" />

            <asp:Parameter Name="sandsVerified" Type="String" />

            <asp:Parameter Name="equipVerified" Type="String" />

            <asp:Parameter Name="ldrSub" Type="String" />

            <asp:Parameter Name="appReportAttached" Type="String" />

            <asp:Parameter Name="clientSupplyPW" Type="String" />

            <asp:Parameter Name="deploySched" Type="String" />

            <asp:Parameter Name="uatSched" Type="String" />

            <asp:Parameter Name="uatStatus" Type="String" />

            <asp:Parameter Name="comments" Type="String" />

        </InsertParameters>

    </asp:SqlDataSource>

    <asp:SqlDataSource ID="SqlDataSource9" runat="server" 

        ConnectionString="<%$ ConnectionStrings:VDIConnectionString %>" 

        

        

        

        

        SelectCommand="SELECT * FROM [BVF_Metrics] WHERE [affectedSid] = @affectedSid OR [affectedLastName] LIKE '%' + @affectedLastName + '%'">

        <SelectParameters>

            <asp:ControlParameter ControlID="INCSEARCH" Name="affectedSid" 

                PropertyName="Text" Type="String" />

            <asp:ControlParameter ControlID="INCSEARCH" Name="affectedLastName" 

                PropertyName="Text" Type="String" />

        </SelectParameters>

    </asp:SqlDataSource>

    <br />

    </form>

</body>

</html>

Open in new window

0
Comment
Question by:donbenson
  • 7
  • 5
13 Comments
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24739956
That would work in query analyzer as a multiple line query that you could put in a stored procedure or something like that, but as a standalone select statement that is not proper syntax.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24739996
Try replacing code on lines 1223-1236 with this code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 

        ConnectionString="<%$ ConnectionStrings:VDIConnectionString %>" 

	SelectCommand="SELECT [incidentId], [createDate], [eurcNumber], [status], [incidentType], [incidentDetailed], [assignedSid], [assignedLastName], [assignedFirstName], [assignedemail],[affectedSid], [affectedLastName], [affectedFirstName], [building] FROM [BVF_Metrics] WHERE ((@INCSEARCH IS NULL AND [incidentType] = @incidentType) OR ([affectedsid] = @affectedsid OR [affectedlastname] = @affectedlastname OR [eurcnumber] = @eurcnumber)) AND [status] NOT LIKE 'COMPLETE%'  ORDER BY [createDate]">

Open in new window

0
 

Author Comment

by:donbenson
ID: 24740013
Can you use a stored procedure to populate a Gridview?
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24740067
0
 

Author Comment

by:donbenson
ID: 24740178
appreciate the help mwvisa1, but got the same results with your code as well.  Issue seems that the gridview will not post the results of the IF NULL part of the query.  Searching with any criteria works fine....Perhaps I will try wrting the stored procedure and see if that will work.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24740198
Maybe it is not NULL but empty string ''.  Stored procedure probably won't hurt to try, but you can also try like this:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 

        ConnectionString="<%$ ConnectionStrings:VDIConnectionString %>" 

	SelectCommand="SELECT [incidentId], [createDate], [eurcNumber], [status], [incidentType], [incidentDetailed], [assignedSid], [assignedLastName], [assignedFirstName], [assignedemail],[affectedSid], [affectedLastName], [affectedFirstName], [building] FROM [BVF_Metrics] WHERE ((ISNULL(@INCSEARCH, '') = '' AND [incidentType] = @incidentType) OR ([affectedsid] = @affectedsid OR [affectedlastname] = @affectedlastname OR [eurcnumber] = @eurcnumber)) AND [status] NOT LIKE 'COMPLETE%'  ORDER BY [createDate]">

Open in new window

0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:donbenson
ID: 24740257
thanks again, but still the same.  When I test the query in the test query box, it produces exactly what I want, but on the ASP page, nothing...I guess I'll write the SP and see what happens, thanks for your time
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24740301
Good luck!
0
 
LVL 22

Expert Comment

by:8080_Diver
ID: 24740721
I would receommend using a stored procedure and passing parameters to it.  In the stored proc, you can default the parameter that you fill from the text box to an empty string ('') if it is null and then test for the empty string.
 
Another possible solution is to not worry about swapping between the 2 SELECT statements and, instead, to let the SQL handle it:

SELECT [incidentId], [createDate], [eurcNumber], 

       [status], [incidentType], [incidentDetailed], 

       [assignedSid], [assignedLastName], [assignedFirstName], 

       [assignedemail],[affectedSid], [affectedLastName], 

       [affectedFirstName], [building] 

FROM [BVF_Metrics] 

WHERE (((@INCSEARCH IS NULL) AND

        ([incidentType] = @incidentType)) OR

       ((@INCSEARCH IS NOT NULL) OR

        ([affectedsid] = @affectedsid) OR

        ([eurcnumber]=@eurcnumber)))

    AND ([status] NOT LIKE 'COMPLETE%')  

ORDER BY [createDate]

Open in new window

0
 

Author Comment

by:donbenson
ID: 24743986
OK, I'm at my wits end here.  I have tried this using a SP.  in the SP, I used my original code, mwvisa1's code and 8080 Diver's code and I still get the exact same result as I have been getting.  The frustrating part is that it work absolutely correctly (all ways, with or without SP) in the query test, but will not work on the ASP page.

Attached is my SP (well, the last one that I used)...Regards,
CREATE PROCEDURE Deploy 

	-- Add the parameters for the stored procedure here

	@incsearch nvarchar(200) = NULL, 

	@affectedsid nvarchar(200) = null,

	@affectedlastname nvarchar(200) = null,

	@eurcnumber nvarchar(200) = null,

	@incidenttype nvarchar(200) = null

	

AS

BEGIN

	-- SET NOCOUNT ON added to prevent extra result sets from

	-- interfering with SELECT statements.

	SET NOCOUNT ON;
 

    -- Insert statements for procedure here

	SELECT [incidentId], [createDate], [eurcNumber], 

[status], [incidentType], [incidentDetailed], [assignedSid],

[assignedLastName], [assignedFirstName], 

[assignedemail],[affectedSid], [affectedLastName], 

[affectedFirstName], [building] FROM [BVF_Metrics]

WHERE ((ISNULL(@INCSEARCH, '') = '' 

AND [incidentType] = @incidentType) OR 

([affectedsid] = @affectedsid OR [affectedlastname] = @affectedlastname OR 

[eurcnumber] = @eurcnumber)) AND [status] NOT LIKE 'COMPLETE%'  

ORDER BY [createDate]

END

GO

Open in new window

0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24744286
I would debug the ASP.NET page.  Maybe turn tracing on and write trace messages out on what the value of @incsearch and @incidenttype are then see if you can tell what is going wrong by examining the trace.axd.

Regards,
Kevin
0
 

Accepted Solution

by:
donbenson earned 0 total points
ID: 24896969
I figured this one out.  If you add "search" as the default (or any word) you can use the IF ELSE off of that and the code will work as written.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24897048
donbenson,

Glad you found a working solution.

Happy coding!

Regards,
isa
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now