ASP.NET

HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List. RSS

73 replies

Last post May 09, 2012 03:30 PM by bbcompent1

‹ Previous Thread|Next Thread ›

- Reply
bbcompent1

All-Star

32974 Points

8500 Posts

Moderator

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

May 08, 2012 07:05 PM|LINK

Yeah, what I'm seeing is it sets the selected value to the first item instead of the selected value. I think this is one of those crazy postback issues. You probably again want to use SelectedIndexChanged instead of autopostback.

Mark as answer posts that helped you.
- Reply
eyeguy1

Member

2 Points

61 Posts

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

May 08, 2012 07:11 PM|LINK

Wonderful... If there is a way to find something crazy then I will do it. I am lost already at this point. I have been working on this issue for over a week and a half now, and cant seem to get it figured out. I think I have looked at and read every code example I could find on multiple dropdownlists.

I am always up for a challenge but this is getting rediculous. lol
- Reply
eyeguy1

Member

2 Points

61 Posts

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

May 08, 2012 07:16 PM|LINK

Is this something fairly easy to do or is it recoding the entire page?
- Reply
basheerkal

Star

10672 Points

2426 Posts

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

May 08, 2012 07:25 PM|LINK

If you populate the DropdownList in Page_Load event, do it within

if(!Page.IsPostBack)

{

}

Kindly mark this post as "Answer", if it helped you.

(Talk less..Work more)
- Reply
eyeguy1

Member

2 Points

61 Posts

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

May 08, 2012 07:28 PM|LINK

it is. Any more suggestions that may fix this issue? Any and all assistance is much appreciated...

bbcompent1

All-Star

32974 Points

8500 Posts

Moderator

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

May 08, 2012 07:36 PM|LINK

ok, I just went through and cleaned out a lot of the code behind stuff other than your insert statement and the selections maintained. Try this:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ECPOrder.aspx.cs" Inherits="ECPOrder" %>

<!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 id="Head1" runat="server">
    <title></title>
    <style type="text/css">
        .style1
        {
            width: 100%;
            z-index: 1;
            left: 0px;
            top: 7px;
            position: absolute;
            height: 88px;
        }
        .style3
        {
            width: 45px;
            height: 23px;
            font-weight: bold;
            text-align: right;
        }
        .style4
        {
            height: 23px;
        }
        .style5
        {
            height: 9px;
            text-align: center;
            font-weight: bold;
        }
        .style6
        {
            width: 45px;
            height: 9px;
            text-align: center;
        }
        .style7
        {
            height: 9px;
            text-align: center;
            width: 61px;
            font-weight: bold;
        }
        .style9
        {
            height: 23px;
            width: 61px;
        }
        .style10
        {
            height: 9px;
            text-align: center;
            width: 64px;
            font-weight: bold;
        }
        .style12
        {
            height: 23px;
            width: 64px;
        }
        .style13
        {
            height: 9px;
            text-align: center;
            width: 59px;
            font-weight: bold;
        }
        .style15
        {
            height: 23px;
            width: 59px;
        }
        .style16
        {
            height: 9px;
            text-align: center;
            width: 55px;
            font-weight: bold;
        }
        .style18
        {
            height: 23px;
            width: 55px;
        }
        .style22
        {
            height: 9px;
            text-align: center;
            width: 80px;
            font-weight: bold;
        }
        .style24
        {
            height: 23px;
            width: 80px;
        }
        .style25
        {
            height: 9px;
            text-align: center;
            width: 62px;
            font-weight: bold;
        }
        .style27
        {
            height: 23px;
            width: 62px;
        }
        .style28
        {
            height: 9px;
            text-align: center;
            width: 78px;
            font-weight: bold;
        }
        .style30
        {
            height: 23px;
            width: 78px;
        }
        .style31
        {
            height: 9px;
            text-align: center;
            width: 76px;
            font-weight: bold;
        }
        .style33
        {
            height: 23px;
            width: 76px;
        }
        .style34
        {
            width: 100%;
        }
        .style37
        {
            width: 46px;
            font-weight: 700;
            text-align: right;
        }
        .style38
        {
            width: 144px;
        }
        .style40
        {
            width: 46px;
            font-weight: 700;
            text-align: right;
            height: 23px;
        }
        .style41
        {
            width: 144px;
            height: 23px;
        }
        .style43
        {
            height: 23px;
            width: 60px;
            text-align: center;
        }
        .style44
        {
            width: 60px;
        }
        .style45
        {
            height: 23px;
            width: 70px;
        }
        .style46
        {
            width: 70px;
        }
        .style47
        {
            height: 23px;
            text-align: center;
        }
        .style48
        {
            height: 23px;
            width: 66px;
            text-align: center;
        }
        .style49
        {
            width: 66px;
        }
        .style50
        {
            height: 23px;
            text-align: center;
            width: 85px;
        }
        .style51
        {
            width: 85px;
        }
        .style52
        {
            width: 45px;
            height: 14px;
            font-weight: bold;
            text-align: right;
        }
        .style53
        {
            height: 14px;
            width: 64px;
        }
        .style54
        {
            height: 14px;
            width: 61px;
        }
        .style55
        {
            height: 14px;
            width: 55px;
        }
        .style56
        {
            height: 14px;
            width: 59px;
        }
        .style57
        {
            height: 14px;
            width: 80px;
        }
        .style58
        {
            height: 14px;
            width: 62px;
        }
        .style59
        {
            height: 14px;
            width: 78px;
        }
        .style60
        {
            height: 14px;
            width: 76px;
        }
        .style61
        {
            height: 14px;
        }
        .style62
        {
            color: #FFFFFF;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <asp:Panel ID="Panel16" runat="server"
            style="z-index: 1; left: 76px; top: 23px; position: absolute; height: 130px; width: 1027px">
            <asp:Label ID="Label23" runat="server"
    
                style="z-index: 1; left: 0px; top: 2px; position: absolute; width: 638px; height: 42px;"
                Text="Value Vision Optical, LLC" Font-Bold="True" Font-Italic="True"
                Font-Size="XX-Large" ForeColor="#006699"></asp:Label>
            <asp:Label ID="Label24" runat="server" Font-Italic="True" ForeColor="Maroon"
                style="z-index: 1; left: 137px; top: 42px; position: absolute"
                Text="&quot;Get more Value for your Vision&quot;"></asp:Label>
            <asp:Label ID="Label25" runat="server" Font-Size="XX-Large"
                style="z-index: 1; left: 123px; position: absolute; width: 768px; text-align: center; top: 80px; font-size: xx-large; color: #003366;"
                Text="Eye Care Provider Portal"></asp:Label>
        </asp:Panel>
    
    </div>
    
    <a target="_blank" href="http://www.website-hit-counters.com/basic-hit-counters.html">

    
   

        <asp:Panel ID="Panel4" runat="server"
            
            
            
        
        
        
        style="z-index: 0; left: 72px; top: 168px; position: absolute; height: 29px; width: 1159px; background-color: #003366;">
            &nbsp;
            <asp:HyperLink ID="HyperLink2" runat="server" Font-Bold="True" Font-Underline="False"
                ForeColor="White" NavigateUrl="http://www.valuevisionoptical.com/AboutUs.aspx"
                Style="z-index: 1; left: 131px; top: 3px; position: absolute">About Value Vision Optical</asp:HyperLink>
            &nbsp;
            <asp:HyperLink ID="HyperLink4" runat="server" Font-Bold="True" Font-Underline="False"
                ForeColor="White" NavigateUrl="http://www.valuevisionoptical.com/Frames.aspx"
                Style="z-index: 1; left: 473px; top: 3px; position: absolute">Eyewear Frames</asp:HyperLink>
            &nbsp;&nbsp;&nbsp;
            <asp:HyperLink ID="HyperLink3" runat="server" Font-Bold="True" Font-Underline="False"
                ForeColor="White" NavigateUrl="http://www.valuevisionoptical.com/ContactLensList.aspx"
                Style="z-index: 1; left: 338px; top: 3px; position: absolute">Contact Lenses</asp:HyperLink>
            &nbsp;
            <asp:HyperLink ID="HyperLink7" runat="server" Font-Bold="True" Font-Underline="False"
                ForeColor="White" NavigateUrl="http://www.valuevisionoptical.com/Accessories.aspx"
                Style="z-index: 1; left: 941px; top: 3px; position: absolute">Accessories</asp:HyperLink>
&nbsp;
            <asp:HyperLink ID="HyperLink5" runat="server" Font-Bold="True" Font-Underline="False"
                ForeColor="White" Style="z-index: 1; left: 623px; top: 3px; position: absolute"
                NavigateUrl="http://www.valuevisionoptical.com/LensList.aspx">Prescription Lenses</asp:HyperLink>
&nbsp;
            <asp:HyperLink ID="HyperLink6" runat="server" Font-Bold="True" Font-Underline="False"
    ForeColor="White" NavigateUrl="http://www.valuevisionoptical.com/Treatments.aspx"
    Style="z-index: 1; left: 789px; top: 3px; position: absolute">Lens Treatments</asp:HyperLink>
&nbsp;
            <asp:HyperLink ID="HyperLink8" runat="server" Font-Bold="True" Font-Underline="False"
    ForeColor="White" NavigateUrl="http://www.valuevisionoptical.com/ContactUs.aspx"
    Style="z-index: 1; left: 1062px; top: 3px; position: absolute; width: 150px">Contact Us</asp:HyperLink>
&nbsp;
            <asp:HyperLink ID="HyperLink1" runat="server" Font-Bold="True" Font-Underline="False"
    ForeColor="White" NavigateUrl="http://www.valuevisionoptical.com/Homepage.aspx"
    Style="z-index: 1; left: 32px; top: 3px; position: absolute; right: 1055px;">Homepage</asp:HyperLink>
            <a href="http://www.website-hit-counters.com/basic-hit-counters.html"
                target="_blank">
            <asp:Image ID="Image3" runat="server"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                
                style="z-index: 2; left: 117px; top: 0px; position: absolute; width: 3px; right: 1039px; height: 26px;" />
            <asp:Image ID="Image4" runat="server"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                style="z-index: 2; left: 325px; top: 0px; position: absolute; width: 3px; right: 831px; height: 26px;" />
            <asp:Image ID="Image5" runat="server"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                style="z-index: 2; left: 921px; top: 0px; position: absolute; width: 3px; right: 235px; height: 26px;" />
            <asp:Image ID="Image6" runat="server"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                style="z-index: 2; left: 1037px; top: 0px; position: absolute; width: 3px; right: 119px; height: 26px;" />
            <asp:Image ID="Image7" runat="server"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                style="z-index: 2; left: 772px; top: 0px; position: absolute; width: 3px; right: 384px; height: 26px;" />
            <asp:Image ID="Image8" runat="server"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                style="z-index: 2; left: 603px; top: 0px; position: absolute; width: 3px; right: 553px; height: 26px;" />
            <asp:Image ID="Image9" runat="server"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                style="z-index: 2; left: 457px; top: 0px; position: absolute; width: 3px; right: 699px; height: 26px;" />
            </a>
        </asp:Panel>
    
    
   

    </a>
    
    

    
   

    <asp:Panel ID="Panel5" runat="server"
        
        style="z-index: 1; left: 228px; top: 360px; position: absolute; height: 691px; width: 710px">
        <asp:Label ID="Label1" runat="server" Text="Please Enter Patient Name"
            BackColor="#003366" Font-Bold="True" ForeColor="White"
            style="z-index: 1; left: 0px; top: 0px; position: absolute; width: 708px; height: 24px"></asp:Label>
        <asp:Label ID="Label2" runat="server"
            style="z-index: 1; left: 9px; top: 37px; position: absolute" Text="Last Name:"></asp:Label>
        <asp:Panel ID="Panel14" runat="server" BackColor="#003366"
            
            style="z-index: 0; left: 0px; top: -42px; position: absolute; height: 27px; width: 710px">
            &nbsp;<span class="style62"><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account
            Number:</strong></span>
            <asp:Label ID="lblAccountNumber" runat="server" Font-Bold="True"
                ForeColor="White" style="z-index: 1; left: 307px; top: 2px; position: absolute"></asp:Label>
        </asp:Panel>
             
        <asp:TextBox ID="txtLastname" runat="server"
            
            
            style="z-index: 1; left: 87px; top: 35px; position: absolute; width: 212px"
            TabIndex="2"></asp:TextBox>
        <asp:Label ID="Label3" runat="server"
            style="z-index: 1; left: 325px; top: 37px; position: absolute"
            Text="First Name:"></asp:Label>
        <asp:TextBox ID="txtFirstname" runat="server"
            style="z-index: 1; left: 405px; top: 35px; position: absolute"
            TabIndex="3"></asp:TextBox>
        <asp:Label ID="Label4" runat="server" BackColor="#003366" Font-Bold="True"
            ForeColor="White"
            style="z-index: 1; left: 0px; top: 77px; position: absolute; width: 708px; height: 24px; bottom: 384px"
            Text="Please Enter Lens Data:"></asp:Label>
        <asp:Panel ID="Panel6" runat="server"
            
            style="z-index: 1; left: 0px; top: 107px; position: absolute; height: 66px; width: 710px">
            <asp:Label ID="Label5" runat="server"
                style="z-index: 1; left: 13px; top: 0px; position: absolute" Text="Job Type:"></asp:Label>
            <asp:Label ID="Label6" runat="server"
                style="z-index: 1; left: 10px; top: 30px; position: absolute">Order Lens(es):</asp:Label>
            <asp:RadioButtonList ID="rdoJobType" runat="server"
                RepeatDirection="Horizontal"
                
                
                style="z-index: 1; left: 131px; top: -3px; position: absolute; height: 27px; width: 492px"
                TabIndex="4">
                <asp:ListItem Selected="True">Uncut</asp:ListItem>
                <asp:ListItem>Finish (Frame To Come)</asp:ListItem>
                <asp:ListItem>Finish (Supply Frame)</asp:ListItem>
            </asp:RadioButtonList>
            <asp:RadioButtonList ID="rdoOrderType" runat="server"
                RepeatDirection="Horizontal"
                
                style="z-index: 1; left: 131px; top: 26px; position: absolute; height: 27px; width: 477px"
                TabIndex="5">
                <asp:ListItem Selected="True">Pair</asp:ListItem>
                <asp:ListItem>Right (OD) Only</asp:ListItem>
                <asp:ListItem>Left (OS) Only</asp:ListItem>
            </asp:RadioButtonList>
        </asp:Panel>
        <asp:Panel ID="Panel7" runat="server"
            style="z-index: 1; left: 0px; top: 179px; position: absolute; height: 69px; width: 710px">
            <asp:Label ID="Label7" runat="server" Font-Bold="True"
                style="z-index: 1; left: 169px; top: -3px; position: absolute; width: 146px;"
                Text="Select Lens Material"></asp:Label>
            <asp:Label ID="Label8" runat="server" Font-Bold="True"
                style="z-index: 1; left: 483px; top: -2px; position: absolute"
                Text="Select Lens Style"></asp:Label>
            <asp:Label ID="Label9" runat="server"
                style="z-index: 1; left: 5px; top: 20px; position: absolute"
                Text="Please Select Material:"></asp:Label>
            <asp:DropDownList ID="cboODMaterial" runat="server" OnSelectedIndexChanged="btnSelectOD_Click"
                style="z-index: 1; left: 168px; top: 18px; position: absolute; width: 143px; height: 22px"
                TabIndex="6" AutoPostBack="True">
                <asp:ListItem Value="-1">-- Select --</asp:ListItem>
                <asp:ListItem Value="1">CR-39</asp:ListItem>
                <asp:ListItem Value="2">Polycarbonate</asp:ListItem>
            </asp:DropDownList>
            <asp:DropDownList ID="cboODStyle" runat="server"
                
                
                style="z-index: 1; left: 409px; top: 17px; position: absolute; width: 248px"
                TabIndex="7" DataSourceID="dsLensTypes" DataTextField="Description"
                DataValueField="LensID"
                onselectedindexchanged="cboODStyle_SelectedIndexChanged">
            </asp:DropDownList>
            <asp:SqlDataSource ID="dsLensTypes" runat="server"
                ConnectionString="<%$ ConnectionStrings:ValueVision %>"
                SelectCommand="SELECT [LensID], [Description] FROM [ECPLensType1] WHERE ([LensID] = @LensID)">
                <SelectParameters>
                    <asp:ControlParameter ControlID="cboODMaterial" Name="LensID"
                        PropertyName="SelectedValue" Type="Int32" />
                </SelectParameters>
            </asp:SqlDataSource>
            <asp:Panel ID="Panel13" runat="server"
                
                style="z-index: 1; left: 170px; top: -247px; position: absolute; height: 25px; width: 540px">
                <asp:Label ID="lblWelcome" runat="server" Font-Italic="True" ForeColor="Maroon"
                    
                    style="z-index: 1; left: 68px; top: 0px; position: absolute; width: 433px; height: 22px;"
                    Font-Size="Large"></asp:Label>
                <asp:Panel ID="Panel15" runat="server" BackColor="#003366"
                    style="z-index: 0; left: -157px; top: -59px; position: absolute; height: 27px; width: 928px">
                    <asp:HyperLink ID="HyperLink27" runat="server" Font-Bold="True"
                        Font-Underline="False" ForeColor="White" NavigateUrl="ECPHomepage.aspx"
                        style="z-index: 1; left: 26px; top: 3px; position: absolute">ECP Homepage</asp:HyperLink>
                    <asp:HyperLink ID="HyperLink28" runat="server" Font-Bold="True"
                        Font-Underline="False" ForeColor="White" NavigateUrl="ECPOrder.aspx"
                        style="z-index: 1; left: 189px; top: 3px; position: absolute">Place Job Order</asp:HyperLink>
                    <asp:HyperLink ID="HyperLink29" runat="server" Font-Bold="True"
                        Font-Underline="False" ForeColor="White" NavigateUrl="ECPAccountBalance.aspx"
                        style="z-index: 1; left: 356px; top: 3px; position: absolute; right: 457px">View Account</asp:HyperLink>
                    <asp:HyperLink ID="HyperLink30" runat="server" Font-Bold="True"
                        Font-Underline="False" ForeColor="White" NavigateUrl="ECPViewOrders.aspx"
                        style="z-index: 1; left: 501px; top: 3px; position: absolute">View Job Status</asp:HyperLink>
                    <asp:HyperLink ID="HyperLink31" runat="server" Font-Bold="True"
                        Font-Underline="False" ForeColor="White" NavigateUrl="ECPProfile.aspx"
                        style="z-index: 1; left: 657px; top: 3px; position: absolute">ECP Profile</asp:HyperLink>
                    <asp:Image ID="Image24" runat="server" BackColor="White"
                        ImageUrl="~/SiteImages/Design/VertLine.jpg"
                        style="z-index: 3; left: 760px; top: -2px; position: absolute; height: 29px; width: 3px" />
                    <asp:Image ID="Image25" runat="server" BackColor="White"
                        ImageUrl="~/SiteImages/Design/VertLine.jpg"
                        style="z-index: 3; left: 632px; top: -2px; position: absolute; height: 29px; width: 3px; right: 293px;" />
                    <asp:Image ID="Image26" runat="server" BackColor="White"
                        ImageUrl="~/SiteImages/Design/VertLine.jpg"
                        style="z-index: 3; left: 474px; top: -2px; position: absolute; height: 29px; width: 3px" />
                    <asp:HyperLink ID="HyperLink32" runat="server" Font-Bold="True"
                        Font-Underline="False" ForeColor="White" NavigateUrl="~/ContactUs.aspx"
                        style="z-index: 1; left: 783px; top: 3px; position: absolute">Customer Service</asp:HyperLink>
                    <asp:Image ID="Image27" runat="server" BackColor="White"
                        ImageUrl="~/SiteImages/Design/VertLine.jpg"
                        style="z-index: 4; left: 329px; top: -2px; position: absolute; height: 29px; width: 3px" />
                    <asp:Image ID="Image23" runat="server" BackColor="White"
                        ImageUrl="~/SiteImages/Design/VertLine.jpg"
                        style="z-index: 4; left: 161px; top: -2px; position: absolute; height: 29px; width: 3px" />
                </asp:Panel>
            </asp:Panel>
            <asp:Label ID="lblStyle" runat="server"
                
                style="z-index: 1; left: 724px; top: -26px; position: absolute; width: 165px"></asp:Label>
            <asp:Button ID="btnSelectStyle" runat="server" onclick="btnSelectStyle_Click"
                style="z-index: 1; left: 669px; top: 15px; position: absolute" Text="Select" />
        </asp:Panel>
        <asp:Panel ID="Panel9" runat="server"
            style="z-index: 1; left: 0px; top: 265px; position: absolute; height: 99px; width: 710px">
            <table class="style1">
                <tr>
                    <td class="style6">
                    </td>
                    <td class="style10">
                        Sphere</td>
                    <td class="style7">
                        Cylinder</td>
                    <td class="style16">
                        Axis</td>
                    <td class="style13">
                        Add</td>
                    <td class="style22">
                        Dist PD</td>
                    <td class="style25">
                        Near PD</td>
                    <td class="style28">
                        Seg Ht</td>
                    <td class="style31">
                        OC Ht</td>
                    <td class="style5">
                        Base</td>
                </tr>
                <tr>
                    <td class="style52">
                        R:</td>
                    <td class="style53">
                        &nbsp;</td>
                    <td class="style54">
                        <asp:TextBox ID="txtODCyl" runat="server"
                            
                            
                            
                            style="z-index: 1; left: 124px; top: 30px; position: absolute; width: 52px"
                            TabIndex="11"></asp:TextBox>
                    </td>
                    <td class="style55">
                        <asp:TextBox ID="txtODAxis" runat="server"
                            
                            
                            style="z-index: 1; left: 188px; top: 30px; position: absolute; width: 52px"
                            TabIndex="12"></asp:TextBox>
                    </td>
                    <td class="style56">
                        <asp:TextBox ID="txtODAdd" runat="server"
                            
                            
                            
                            style="z-index: 1; left: 249px; top: 30px; position: absolute; width: 52px"
                            TabIndex="13"></asp:TextBox>
                    </td>
                    <td class="style57">
                        <asp:TextBox ID="txtODDistPD" runat="server"
                            
                            
                            
                            style="z-index: 1; left: 322px; top: 30px; position: absolute; width: 52px"
                            TabIndex="14"></asp:TextBox>
                    </td>
                    <td class="style58">
                        <asp:TextBox ID="txtODNearPD" runat="server"
                            
                            
                            
                            style="z-index: 1; left: 395px; top: 30px; position: absolute; width: 52px"
                            TabIndex="15"></asp:TextBox>
                    </td>
                    <td class="style59">
                        <asp:TextBox ID="txtODSegHt" runat="server"
                            
                            
                            
                            style="z-index: 1; left: 470px; top: 30px; position: absolute; width: 52px"
                            TabIndex="16"></asp:TextBox>
                    </td>
                    <td class="style60">
                        <asp:TextBox ID="txtODOCHt" runat="server"
                            
                            
                            
                            style="z-index: 1; left: 551px; top: 30px; position: absolute; width: 52px"
                            TabIndex="17"></asp:TextBox>
                    </td>
                    <td class="style61">
                        <asp:TextBox ID="txtODBase" runat="server"
                            
                            
                            
                            style="z-index: 1; left: 639px; top: 30px; position: absolute; width: 52px"
                            TabIndex="18"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <td class="style3">
                        L:</td>
                    <td class="style12">
                        <asp:TextBox ID="txtODSph" runat="server"
                            
                            
                            
                            style="z-index: 1; left: 59px; top: 30px; position: absolute; width: 52px; right: 599px"
                            TabIndex="10"></asp:TextBox>
                        <asp:TextBox ID="txtOSSph" runat="server"
                            style="z-index: 1; left: 59px; top: 56px; position: absolute; width: 52px"
                            TabIndex="19"></asp:TextBox>
                    </td>
                    <td class="style9">
                        <asp:TextBox ID="txtOSCyl" runat="server"
                            
                            
                            style="z-index: 1; left: 125px; top: 56px; position: absolute; width: 52px; right: 533px"
                            TabIndex="20"></asp:TextBox>
                    </td>
                    <td class="style18">
                        <asp:TextBox ID="txtOSAxis" runat="server"
                            
                            
                            style="z-index: 1; left: 189px; top: 56px; position: absolute; width: 52px; right: 469px"
                            TabIndex="21"></asp:TextBox>
                    </td>
                    <td class="style15">
                        <asp:TextBox ID="txtOSAdd" runat="server"
                            
                            style="z-index: 1; left: 249px; top: 56px; position: absolute; height: 22px; width: 52px"
                            TabIndex="22"></asp:TextBox>
                    </td>
                    <td class="style24">
                        <asp:TextBox ID="txtOSDistPD" runat="server"
                            
                            
                            style="z-index: 1; left: 322px; top: 56px; position: absolute; width: 52px"
                            TabIndex="23"></asp:TextBox>
                    </td>
                    <td class="style27">
                        <asp:TextBox ID="txtOSNearPD" runat="server"
                            
                            
                            style="z-index: 1; left: 396px; top: 56px; position: absolute; width: 52px"
                            TabIndex="24"></asp:TextBox>
                    </td>
                    <td class="style30">
                        <asp:TextBox ID="txtOSSegHt" runat="server"
                            
                            
                            style="z-index: 1; left: 471px; top: 56px; position: absolute; width: 52px"
                            TabIndex="25"></asp:TextBox>
                    </td>
                    <td class="style33">
                        <asp:TextBox ID="txtOSOCHt" runat="server"
                            
                            
                            style="z-index: 1; left: 552px; top: 56px; position: absolute; width: 52px"
                            TabIndex="26"></asp:TextBox>
                    </td>
                    <td class="style4">
                        <asp:TextBox ID="txtOSBase" runat="server"
                            
                            
                            style="z-index: 1; left: 639px; top: 56px; position: absolute; width: 52px"
                            TabIndex="27"></asp:TextBox>
                    </td>
                </tr>
            </table>
        </asp:Panel>
        <asp:Panel ID="Panel10" runat="server"
            style="z-index: 1; left: 0px; top: 384px; position: absolute; height: 54px; width: 710px">
            <table class="style34">
                <tr>
                    <td class="style40">
                        R:</td>
                    <td class="style41">
                        <asp:DropDownList ID="cboODPrismDir1" runat="server"
                            style="z-index: 1; left: 134px; top: 3px; position: absolute"
                            TabIndex="29">
                            <asp:ListItem>In</asp:ListItem>
                            <asp:ListItem>Out</asp:ListItem>
                        </asp:DropDownList>
                        <asp:TextBox ID="txtODPrism" runat="server"
                            
                            
                            style="z-index: 1; left: 59px; top: 2px; position: absolute; width: 52px; right: 599px"
                            TabIndex="28"></asp:TextBox>
                    </td>
                    <td class="style45">
                        <asp:TextBox ID="txtODPrism2" runat="server"
                            style="z-index: 1; left: 201px; top: 3px; position: absolute; width: 52px"
                            TabIndex="30"></asp:TextBox>
                    </td>
                    <td class="style4">
                        <asp:DropDownList ID="cboODPrismDir2" runat="server"
                            style="z-index: 1; left: 275px; top: 3px; position: absolute"
                            TabIndex="31">
                            <asp:ListItem>Up</asp:ListItem>
                            <asp:ListItem>Down</asp:ListItem>
                        </asp:DropDownList>
                    </td>
                    <td class="style4">
                    </td>
                    <td class="style48">
                        <asp:Label ID="Label21" runat="server" BackColor="#003366" Font-Bold="True"
                            ForeColor="White"
                            style="z-index: 1; left: 375px; top: -27px; position: absolute; width: 333px; height: 27px; text-align: left"
                            Text="Frame Data"></asp:Label>
                        A</td>
                    <td class="style43">
                        B</td>
                    <td class="style47">
                        ED</td>
                    <td class="style50">
                        DBL</td>
                    <td class="style4">
                    </td>
                </tr>
                <tr>
                    <td class="style37">
                        L:</td>
                    <td class="style38">
                        <asp:DropDownList ID="cboOSPrismDir1" runat="server"
                            
                            style="z-index: 1; left: 134px; top: 26px; position: absolute; right: 529px"
                            TabIndex="33">
                            <asp:ListItem>In</asp:ListItem>
                            <asp:ListItem>Out</asp:ListItem>
                        </asp:DropDownList>
                        <asp:TextBox ID="txtOSPrism" runat="server"
                            style="z-index: 1; left: 58px; top: 26px; position: absolute; width: 52px"
                            TabIndex="32"></asp:TextBox>
                    </td>
                    <td class="style46">
                        <asp:TextBox ID="txtOSPrism2" runat="server"
                            
                            
                            style="z-index: 1; left: 201px; top: 28px; position: absolute; width: 52px"
                            TabIndex="34"></asp:TextBox>
                    </td>
                    <td>
                        <asp:DropDownList ID="cboOSPrismDir2" runat="server"
                            style="z-index: 1; left: 275px; top: 28px; position: absolute"
                            TabIndex="35">
                            <asp:ListItem>Up</asp:ListItem>
                            <asp:ListItem>Down</asp:ListItem>
                        </asp:DropDownList>
                    </td>
                    <td>
                        &nbsp;</td>
                    <td class="style49">
                        <asp:TextBox ID="txtA" runat="server"
                            
                            
                            style="z-index: 1; left: 371px; top: 28px; position: absolute; width: 52px"
                            TabIndex="36"></asp:TextBox>
                    </td>
                    <td class="style44">
                        <asp:TextBox ID="txtB" runat="server"
                            
                            
                            style="z-index: 1; left: 438px; top: 28px; position: absolute; width: 52px; right: 220px"
                            TabIndex="37"></asp:TextBox>
                    </td>
                    <td>
                        <asp:TextBox ID="txtED" runat="server"
                            
                            
                            style="z-index: 1; left: 508px; top: 28px; position: absolute; width: 52px; right: 150px"
                            TabIndex="38"></asp:TextBox>
                    </td>
                    <td class="style51">
                        <asp:TextBox ID="txtDBL" runat="server"
                            
                            
                            style="z-index: 1; left: 591px; top: 28px; position: absolute; width: 52px"
                            TabIndex="39"></asp:TextBox>
                    </td>
                    <td>
                        &nbsp;</td>
                </tr>
            </table>
        </asp:Panel>
        <asp:Panel ID="Panel11" runat="server"
            style="z-index: 1; left: 0px; top: 448px; position: absolute; height: 363px; width: 710px">
            <asp:RadioButtonList ID="rdoMountType" runat="server"
                
                
                style="z-index: 1; left: 10px; top: 38px; position: absolute; height: 27px; width: 190px; right: 510px;"
                TabIndex="40">
                <asp:ListItem Selected="True">Zyl  ($7.99)</asp:ListItem>
                <asp:ListItem>Metal ($7.99)</asp:ListItem>
                <asp:ListItem>Semi-Rimless ($12.99)</asp:ListItem>
                <asp:ListItem>Rimless ($25.99)</asp:ListItem>
                <asp:ListItem>Wrap Frame (15.99)</asp:ListItem>
            </asp:RadioButtonList>
            <asp:Label ID="Label11" runat="server" Font-Bold="True" Font-Underline="True"
                style="z-index: 1; left: 48px; top: 16px; position: absolute; width: 72px"
                Text="Mount"></asp:Label>
            <asp:Label ID="Label12" runat="server" Font-Bold="True" Font-Underline="True"
                style="z-index: 1; left: 188px; top: 16px; position: absolute" Text="Thickness"></asp:Label>
            <asp:RadioButtonList ID="rdoThickness" runat="server"
                
                
                style="z-index: 1; left: 180px; top: 36px; position: absolute; height: 27px; width: 179px"
                TabIndex="41">
                <asp:ListItem Selected="True">Standard Thickness</asp:ListItem>
                <asp:ListItem>Industrial 3.0 ($5.99)</asp:ListItem>
            </asp:RadioButtonList>
            <asp:Label ID="Label13" runat="server" Font-Bold="True" Font-Underline="True"
                style="z-index: 1; left: 366px; top: 16px; position: absolute" Text="Tinting"></asp:Label>
            <asp:Label ID="Label14" runat="server" Font-Bold="True" Font-Underline="True"
                style="z-index: 1; left: 529px; top: 16px; position: absolute; width: 175px"
                Text="Anti-Reflective Coating"></asp:Label>
            <asp:RadioButtonList ID="rdoARCoating" runat="server"
                
                
                style="z-index: 1; left: 527px; top: 41px; position: absolute; height: 27px; width: 225px"
                TabIndex="45">
                <asp:ListItem Selected="True">No AR</asp:ListItem>
                <asp:ListItem>Standard AR ($21.99)</asp:ListItem>
                <asp:ListItem>ICE AR ($31.99)</asp:ListItem>
                <asp:ListItem>Crizal Easy (44.99)</asp:ListItem>
                <asp:ListItem>Crizal Alize (51.99)</asp:ListItem>
                <asp:ListItem>Crizal Sun ($51.99)</asp:ListItem>
                <asp:ListItem>Crizal Avance (57.99)</asp:ListItem>
                <asp:ListItem>Crizal OptiFog ($73.99)</asp:ListItem>
                <asp:ListItem>Kodak CleAR ($51.99)</asp:ListItem>
                <asp:ListItem>Hoya Super HiVision ($57.99)</asp:ListItem>
            </asp:RadioButtonList>
            <asp:RadioButtonList ID="rdoTinting" runat="server"
                
                
                style="z-index: 1; left: 349px; top: 37px; position: absolute; height: 27px; width: 167px"
                TabIndex="42">
                <asp:ListItem Selected="True">No Tint</asp:ListItem>
                <asp:ListItem>Solid Tint ($3.99)</asp:ListItem>
                <asp:ListItem>Gradient Tint ($5.99)</asp:ListItem>
            </asp:RadioButtonList>
            <asp:Label ID="Label15" runat="server"
                style="z-index: 1; left: 310px; top: 122px; position: absolute"
                Text="Tint Color:"></asp:Label>
            <asp:DropDownList ID="cboTintColor" runat="server"
                style="z-index: 1; left: 386px; top: 118px; position: absolute"
                TabIndex="43">
                <asp:ListItem>No Tint</asp:ListItem>
                <asp:ListItem>Black</asp:ListItem>
                <asp:ListItem>Gray</asp:ListItem>
                <asp:ListItem>Brown</asp:ListItem>
                <asp:ListItem>Blue</asp:ListItem>
                <asp:ListItem>Yellow</asp:ListItem>
                <asp:ListItem>Rose</asp:ListItem>
            </asp:DropDownList>
            <asp:Label ID="Label16" runat="server"
                style="z-index: 1; left: 275px; top: 150px; position: absolute"
                Text="Transmission %:"></asp:Label>
            <asp:DropDownList ID="cboTransmission" runat="server"
                style="z-index: 1; left: 387px; top: 147px; position: absolute"
                TabIndex="44">
                <asp:ListItem>0</asp:ListItem>
                <asp:ListItem>10</asp:ListItem>
                <asp:ListItem>20</asp:ListItem>
                <asp:ListItem>30</asp:ListItem>
                <asp:ListItem>40</asp:ListItem>
                <asp:ListItem>50</asp:ListItem>
                <asp:ListItem>60</asp:ListItem>
                <asp:ListItem>70</asp:ListItem>
                <asp:ListItem>80</asp:ListItem>
                <asp:ListItem>90</asp:ListItem>
            </asp:DropDownList>
            <asp:Label ID="Label17" runat="server"
                style="z-index: 1; left: 53px; top: 264px; position: absolute"
                Text="Special Instructions:"></asp:Label>
            <asp:TextBox ID="txtSpecialInstructions" runat="server" MaxLength="250" Rows="2"
                
                
                
                style="z-index: 1; left: 183px; top: 266px; position: absolute; width: 314px; height: 45px"
                TabIndex="50"></asp:TextBox>
            <asp:Panel ID="Panel12" runat="server"
                
                style="z-index: 1; left: 317px; top: 240px; position: absolute; height: 19px; width: 143px; background-color: #CCCCCC">
                <asp:CheckBox ID="cbRush" runat="server"
                    style="z-index: 1; left: 6px; top: 0px; position: absolute; width: 143px;"
                    Text="Rush Job ($8.00)" TabIndex="49" />
            </asp:Panel>
            <asp:Button ID="btnSubmit" runat="server"
                style="z-index: 1; left: 571px; top: 326px; position: absolute"
                Text="Submit Order" onclick="btnSubmit_Click" TabIndex="51" />
            <asp:CheckBox ID="cbUVFilter" runat="server"
                style="z-index: 1; left: -2px; top: 178px; position: absolute"
                Text="UV Filter ($4.99)" TabIndex="47" />
            <asp:CheckBox ID="cbScratch" runat="server"
                style="z-index: 1; left: -2px; top: 202px; position: absolute"
                Text="Scratch Coating ($9.99)" TabIndex="48" />
            <asp:CheckBox ID="cbRollPolish" runat="server"
                style="z-index: 1; left: -1px; top: 226px; position: absolute; width: 226px;"
                Text="Roll/Polish Edges ($4.99ea)" TabIndex="46" />
            <asp:Label ID="lblError" runat="server" Font-Italic="True" ForeColor="Maroon"
                
                style="z-index: 1; left: 520px; top: 299px; position: absolute; width: 395px"
                Font-Bold="True"></asp:Label>
            <asp:Label ID="Label22" runat="server" BackColor="#003366" Font-Bold="True"
                ForeColor="White"
                style="z-index: 1; left: 0px; top: -10px; position: absolute; width: 708px; height: 27px"
                Text="Treatments and Services"></asp:Label>
        </asp:Panel>
        <asp:Label ID="Label19" runat="server" BackColor="#003366" Font-Bold="True"
            ForeColor="White"
            style="z-index: 1; left: 0px; top: 247px; position: absolute; width: 708px; height: 27px"
            Text="Prescription Data"></asp:Label>
        <asp:Label ID="Label20" runat="server" BackColor="#003366" Font-Bold="True"
            ForeColor="White"
            style="z-index: 1; left: 0px; top: 357px; position: absolute; width: 375px; height: 26px"
            Text="Prescribed Prism"></asp:Label>
    </asp:Panel>
        <asp:Panel ID="Panel8" runat="server" BackColor="#003366"
            
            
        style="z-index: 0; left: 0px; top: -92px; position: absolute; height: 27px; width: 928px">
            <asp:HyperLink ID="HyperLink15" runat="server" Font-Bold="True"
                Font-Underline="False" ForeColor="White" NavigateUrl="~/ECPHomepage.aspx"
                style="z-index: 1; left: 26px; top: 3px; position: absolute">ECP Homepage</asp:HyperLink>
            <asp:HyperLink ID="HyperLink26" runat="server" Font-Bold="True"
                Font-Underline="False" ForeColor="White" NavigateUrl="~/ECPOrder.aspx"
                style="z-index: 1; left: 189px; top: 3px; position: absolute">Place Job Order</asp:HyperLink>
            <asp:HyperLink ID="HyperLink16" runat="server" Font-Bold="True"
                Font-Underline="False" ForeColor="White" NavigateUrl="~/ECPAccountBalance.aspx"
                
                
                style="z-index: 1; left: 356px; top: 3px; position: absolute; right: 457px">View Account</asp:HyperLink>
            <asp:HyperLink ID="HyperLink17" runat="server" Font-Bold="True"
                Font-Underline="False" ForeColor="White" NavigateUrl="~/ECPViewOrders.aspx"
                style="z-index: 1; left: 501px; top: 3px; position: absolute">View Job Status</asp:HyperLink>
            <asp:HyperLink ID="HyperLink18" runat="server" Font-Bold="True"
                Font-Underline="False" ForeColor="White" NavigateUrl="~/ECPProfile.aspx"
                style="z-index: 1; left: 657px; top: 3px; position: absolute">ECP Profile</asp:HyperLink>
            <asp:Image ID="Image17" runat="server" BackColor="White"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                
                
                style="z-index: 3; left: 760px; top: -2px; position: absolute; height: 29px; width: 3px" />
            <asp:Image ID="Image18" runat="server" BackColor="White"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                
                
                style="z-index: 3; left: 632px; top: -2px; position: absolute; height: 29px; width: 3px; right: 293px;" />
            <asp:Image ID="Image19" runat="server" BackColor="White"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                
                
                style="z-index: 3; left: 474px; top: -2px; position: absolute; height: 29px; width: 3px" />
            <asp:Image ID="Image20" runat="server" BackColor="White"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                
                
                style="z-index: 3; left: 324px; top: -2px; position: absolute; height: 29px; width: 3px" />
            <asp:HyperLink ID="HyperLink19" runat="server" Font-Bold="True"
                Font-Underline="False" ForeColor="White"
                style="z-index: 1; left: 783px; top: 3px; position: absolute"
                NavigateUrl="~/ContactUs.aspx">Customer Service</asp:HyperLink>
            <asp:Image ID="Image22" runat="server" BackColor="White"
                ImageUrl="~/SiteImages/Design/VertLine.jpg"
                style="z-index: 3; left: 161px; top: -2px; position: absolute; height: 29px; width: 3px" />
        </asp:Panel>
    </form>
</body>
</html>

using System;
using System.IO;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web.Security;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Net.Mail;

public partial class ECPOrder : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {

        }
        Session["Username"] = "15324561";
        if (Page.Session["Username"] == null && Page.Session["Username"] == null)
        {
            Response.Redirect("ECPLogin.aspx");
        }

        lblWelcome.Text = "Welcome back " + Session["Username"];
        lblAccountNumber.Text = Session["Username"].ToString();

        //if (!IsPostBack)
        //    btnSelectOD_Click(null, null);

    }

    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        Response.Write(cboODStyle.SelectedItem.Text);
        Response.End();
        return;

        string connectionString = ConfigurationManager.ConnectionStrings["ValueVision"].ConnectionString;

        SqlConnection conn = new SqlConnection(connectionString);
        SqlCommand comm;

        conn = new SqlConnection(connectionString);
        comm = new SqlCommand(
            "INSERT INTO OrdersDB (AccountNumber, Username, Lastname, Firstname, JobType, OrderType, ODMaterial, ODStyle, " +
                                "ODSph, ODCyl, ODAxis, ODAdd, ODDistPD, ODNearPD, ODSegHt, ODOCHt, ODBase, " +
                                "OSSph, OSCyl, OSAxis, OSAdd, OSDistPD, OSNearPD, OSSegHt, OSOCHt, OSBase, " +
                                "ODPrism, ODPrismDir1, ODPrism2, ODPrismDir2, OSPrism, OSPrismDir1, OSPrism2, OSPrismDir2, A, B, ED, DBL, MountType," + "Thickness, Tinting, TintColor, Transmission, " +
                                "ARCoating, UVCoat, ScratchCoat, RollPolish, RushJob, SpecialInstructions, Date)" +
                                "VALUES (@AccountNumber, @Username, @Lastname, @Firstname, @JobType, @OrderType, @ODMaterial, @ODStyle," +
                                "@ODSph, @ODCyl, @ODAxis, @ODAdd, @ODDistPD, @ODNearPD, @ODSegHt, @ODOCHt, @ODBase, " +
                                "@OSSph, @OSCyl, @OSAxis, @OSAdd, @OSDistPD, @OSNearPD, @OSSegHt, @OSOCHt, @OSBase, " +
                                "@ODPrism, @ODPrismDir1, @ODPrism2, @ODPrismDir2, @OSPrism, @OSPrismDir1, @OSPrism2, @OSPrismDir2, @A, @B, @ED, @DBL," + "@MountType, @Thickness, @Tinting, @TintColor, @Transmission, " +
                                "@ARCoating, @UVCoat, @ScratchCoat, @RollPolish, @RushJob, @SpecialInstructions, @Date)", conn);

        //comm.Parameters.Add("@ClientID", SqlDbType.Int).Value;
        comm.Parameters.Add("@AccountNumber", SqlDbType.NVarChar).Value = lblAccountNumber.Text;
        comm.Parameters.Add("@Username", SqlDbType.NVarChar).Value = lblAccountNumber.Text;
        comm.Parameters.Add("@Lastname", SqlDbType.NVarChar).Value = txtLastname.Text;
        comm.Parameters.Add("@Firstname", SqlDbType.NVarChar).Value = txtFirstname.Text;
        comm.Parameters.Add("@JobType", SqlDbType.NVarChar).Value = rdoJobType.SelectedItem.Text;
        comm.Parameters.Add("@OrderType", SqlDbType.NVarChar).Value = rdoOrderType.SelectedItem.Text;
        comm.Parameters.Add("@ODMaterial", SqlDbType.NVarChar).Value = cboODMaterial.SelectedItem.Text;
        comm.Parameters.Add("@ODStyle", SqlDbType.NVarChar).Value = Session["lenstype"];
        //comm.Parameters.Add("@OSMaterial", SqlDbType.NVarChar).Value = cboOSMaterial.SelectedItem.Text;
        //comm.Parameters.Add("@OSStyle", SqlDbType.NVarChar).Value = cboOSStyle.SelectedItem.Text;
        comm.Parameters.Add("@ODSph", SqlDbType.NVarChar).Value = txtODSph.Text;
        comm.Parameters.Add("@ODCyl", SqlDbType.NVarChar).Value = txtODCyl.Text;
        comm.Parameters.Add("@ODAxis", SqlDbType.NVarChar).Value = txtODAxis.Text;
        comm.Parameters.Add("@ODAdd", SqlDbType.NVarChar).Value = txtODAdd.Text;
        comm.Parameters.Add("@ODDistPD", SqlDbType.NVarChar).Value = txtODDistPD.Text;
        comm.Parameters.Add("@ODNearPD", SqlDbType.NVarChar).Value = txtODNearPD.Text;
        comm.Parameters.Add("@ODSegHt", SqlDbType.NVarChar).Value = txtODSegHt.Text;
        comm.Parameters.Add("@ODOCHt", SqlDbType.NVarChar).Value = txtODOCHt.Text;
        comm.Parameters.Add("@ODBase", SqlDbType.NVarChar).Value = txtODBase.Text;
        comm.Parameters.Add("@OSSph", SqlDbType.NVarChar).Value = txtOSSph.Text;
        comm.Parameters.Add("@OSCyl", SqlDbType.NVarChar).Value = txtOSCyl.Text;
        comm.Parameters.Add("@OSAxis", SqlDbType.NVarChar).Value = txtOSAxis.Text;
        comm.Parameters.Add("@OSAdd", SqlDbType.NVarChar).Value = txtOSAdd.Text;
        comm.Parameters.Add("@OSDistPD", SqlDbType.NVarChar).Value = txtOSDistPD.Text;
        comm.Parameters.Add("@OSNearPD", SqlDbType.NVarChar).Value = txtOSNearPD.Text;
        comm.Parameters.Add("@OSSegHt", SqlDbType.NVarChar).Value = txtOSSegHt.Text;
        comm.Parameters.Add("@OSOCHt", SqlDbType.NVarChar).Value = txtOSOCHt.Text;
        comm.Parameters.Add("@OSBase", SqlDbType.NVarChar).Value = txtOSBase.Text;

        comm.Parameters.Add("@ODPrism", SqlDbType.NVarChar).Value = txtODPrism.Text;
        comm.Parameters.Add("@ODPrismDir1", SqlDbType.NVarChar).Value = cboODPrismDir1.SelectedItem.Text;
        comm.Parameters.Add("@ODPrism2", SqlDbType.NVarChar).Value = txtODPrism2.Text;
        comm.Parameters.Add("@ODPrismDir2", SqlDbType.NVarChar).Value = cboODPrismDir2.SelectedItem.Text;

        comm.Parameters.Add("@OSPrism", SqlDbType.NVarChar).Value = txtOSPrism.Text;
        comm.Parameters.Add("@OSPrismDir1", SqlDbType.NVarChar).Value = cboOSPrismDir1.SelectedItem.Text;
        comm.Parameters.Add("@OSPrism2", SqlDbType.NVarChar).Value = txtOSPrism2.Text;
        comm.Parameters.Add("@OSPrismDir2", SqlDbType.NVarChar).Value = cboOSPrismDir2.SelectedItem.Text;

        comm.Parameters.Add("@A", SqlDbType.NVarChar).Value = txtA.Text;
        comm.Parameters.Add("@B", SqlDbType.NVarChar).Value = txtB.Text;
        comm.Parameters.Add("@ED", SqlDbType.NVarChar).Value = txtED.Text;
        comm.Parameters.Add("@DBL", SqlDbType.NVarChar).Value = txtDBL.Text;

        comm.Parameters.Add("@MountType", SqlDbType.NVarChar).Value = rdoMountType.SelectedItem.Text;
        comm.Parameters.Add("@Thickness", SqlDbType.NVarChar).Value = rdoThickness.SelectedItem.Text;
        comm.Parameters.Add("@Tinting", SqlDbType.NVarChar).Value = rdoTinting.SelectedItem.Text;
        comm.Parameters.Add("@TintColor", SqlDbType.NVarChar).Value = cboTintColor.SelectedItem.Text;
        comm.Parameters.Add("@Transmission", SqlDbType.NVarChar).Value = cboTransmission.SelectedItem.Text;

        comm.Parameters.Add("@ARCoating", SqlDbType.NVarChar).Value = rdoARCoating.SelectedItem.Text;
        comm.Parameters.Add("@UVCoat", SqlDbType.NVarChar).Value = cbUVFilter.Checked;
        comm.Parameters.Add("@ScratchCoat", SqlDbType.NVarChar).Value = cbScratch.Checked;
        comm.Parameters.Add("@RollPolish", SqlDbType.NVarChar).Value = cbRollPolish.Checked;
        comm.Parameters.Add("@RushJob", SqlDbType.NVarChar).Value = cbRush.Checked;
        comm.Parameters.Add("@SpecialInstructions", SqlDbType.NVarChar).Value = txtSpecialInstructions.Text;


        comm.Parameters.Add("@Date", SqlDbType.DateTime).Value = DateTime.Now;
        try
        {
            conn.Open();
            comm.ExecuteNonQuery();
            lblError.Text = "Your order has been placed.";

            txtLastname.Text = "";
            txtFirstname.Text = "";

        }
        catch
        {
            lblError.Text = "An Error Occured Processing Your Order.  Please Try Again.";
        }
        finally
        {
            conn.Close();
        }
    }


    bool filled = false;
    protected void btnSelectOD_Click(object sender, EventArgs e)
    {
       // cboODStyle.DataBind();
    }

    protected void btnSelectStyle_Click(object sender, EventArgs e)
    {


    }
    protected void cboODStyle_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}

Mark as answer posts that helped you.

- Reply
eyeguy1

Member

2 Points

61 Posts

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

May 08, 2012 07:43 PM|LINK

Selecting Material from the first ddl does populate the second DDL correctly. However it is still writing the first item to the database and not the selected item. :( <Scratching Head>
- Reply
bbcompent1

All-Star

32974 Points

8500 Posts

Moderator
Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

May 08, 2012 07:45 PM|LINK
I think that could be coming from this:
```
comm.Parameters.Add("@ODMaterial", SqlDbType.NVarChar).Value = cboODMaterial.SelectedItem.Text;
        comm.Parameters.Add("@ODStyle", SqlDbType.NVarChar).Value = Session["lenstype"];
```
Instead of Session["lenstype"] I would instead go with

cboODStyle.SelectedItem.Text
Mark as answer posts that helped you.

bbcompent1

All-Star

32974 Points

8500 Posts

Moderator

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

May 08, 2012 07:48 PM|LINK

So, your button submit event should be this instead:

protected void btnSubmit_Click(object sender, EventArgs e)
    {
        Response.Write(cboODStyle.SelectedItem.Text);
        Response.End();
        return;

        string connectionString = ConfigurationManager.ConnectionStrings["ValueVision"].ConnectionString;

        SqlConnection conn = new SqlConnection(connectionString);
        SqlCommand comm;

        conn = new SqlConnection(connectionString);
        comm = new SqlCommand(
            "INSERT INTO OrdersDB (AccountNumber, Username, Lastname, Firstname, JobType, OrderType, ODMaterial, ODStyle, " +
                                "ODSph, ODCyl, ODAxis, ODAdd, ODDistPD, ODNearPD, ODSegHt, ODOCHt, ODBase, " +
                                "OSSph, OSCyl, OSAxis, OSAdd, OSDistPD, OSNearPD, OSSegHt, OSOCHt, OSBase, " +
                                "ODPrism, ODPrismDir1, ODPrism2, ODPrismDir2, OSPrism, OSPrismDir1, OSPrism2, OSPrismDir2, A, B, ED, DBL, MountType," + "Thickness, Tinting, TintColor, Transmission, " +
                                "ARCoating, UVCoat, ScratchCoat, RollPolish, RushJob, SpecialInstructions, Date)" +
                                "VALUES (@AccountNumber, @Username, @Lastname, @Firstname, @JobType, @OrderType, @ODMaterial, @ODStyle," +
                                "@ODSph, @ODCyl, @ODAxis, @ODAdd, @ODDistPD, @ODNearPD, @ODSegHt, @ODOCHt, @ODBase, " +
                                "@OSSph, @OSCyl, @OSAxis, @OSAdd, @OSDistPD, @OSNearPD, @OSSegHt, @OSOCHt, @OSBase, " +
                                "@ODPrism, @ODPrismDir1, @ODPrism2, @ODPrismDir2, @OSPrism, @OSPrismDir1, @OSPrism2, @OSPrismDir2, @A, @B, @ED, @DBL," + "@MountType, @Thickness, @Tinting, @TintColor, @Transmission, " +
                                "@ARCoating, @UVCoat, @ScratchCoat, @RollPolish, @RushJob, @SpecialInstructions, @Date)", conn);

        //comm.Parameters.Add("@ClientID", SqlDbType.Int).Value;
        comm.Parameters.Add("@AccountNumber", SqlDbType.NVarChar).Value = lblAccountNumber.Text;
        comm.Parameters.Add("@Username", SqlDbType.NVarChar).Value = lblAccountNumber.Text;
        comm.Parameters.Add("@Lastname", SqlDbType.NVarChar).Value = txtLastname.Text;
        comm.Parameters.Add("@Firstname", SqlDbType.NVarChar).Value = txtFirstname.Text;
        comm.Parameters.Add("@JobType", SqlDbType.NVarChar).Value = rdoJobType.SelectedItem.Text;
        comm.Parameters.Add("@OrderType", SqlDbType.NVarChar).Value = rdoOrderType.SelectedItem.Text;
        comm.Parameters.Add("@ODMaterial", SqlDbType.NVarChar).Value = cboODMaterial.SelectedItem.Text;
        comm.Parameters.Add("@ODStyle", SqlDbType.NVarChar).Value = cboODStyle.SelectedItem.Text;
        comm.Parameters.Add("@ODSph", SqlDbType.NVarChar).Value = txtODSph.Text;
        comm.Parameters.Add("@ODCyl", SqlDbType.NVarChar).Value = txtODCyl.Text;
        comm.Parameters.Add("@ODAxis", SqlDbType.NVarChar).Value = txtODAxis.Text;
        comm.Parameters.Add("@ODAdd", SqlDbType.NVarChar).Value = txtODAdd.Text;
        comm.Parameters.Add("@ODDistPD", SqlDbType.NVarChar).Value = txtODDistPD.Text;
        comm.Parameters.Add("@ODNearPD", SqlDbType.NVarChar).Value = txtODNearPD.Text;
        comm.Parameters.Add("@ODSegHt", SqlDbType.NVarChar).Value = txtODSegHt.Text;
        comm.Parameters.Add("@ODOCHt", SqlDbType.NVarChar).Value = txtODOCHt.Text;
        comm.Parameters.Add("@ODBase", SqlDbType.NVarChar).Value = txtODBase.Text;
        comm.Parameters.Add("@OSSph", SqlDbType.NVarChar).Value = txtOSSph.Text;
        comm.Parameters.Add("@OSCyl", SqlDbType.NVarChar).Value = txtOSCyl.Text;
        comm.Parameters.Add("@OSAxis", SqlDbType.NVarChar).Value = txtOSAxis.Text;
        comm.Parameters.Add("@OSAdd", SqlDbType.NVarChar).Value = txtOSAdd.Text;
        comm.Parameters.Add("@OSDistPD", SqlDbType.NVarChar).Value = txtOSDistPD.Text;
        comm.Parameters.Add("@OSNearPD", SqlDbType.NVarChar).Value = txtOSNearPD.Text;
        comm.Parameters.Add("@OSSegHt", SqlDbType.NVarChar).Value = txtOSSegHt.Text;
        comm.Parameters.Add("@OSOCHt", SqlDbType.NVarChar).Value = txtOSOCHt.Text;
        comm.Parameters.Add("@OSBase", SqlDbType.NVarChar).Value = txtOSBase.Text;

        comm.Parameters.Add("@ODPrism", SqlDbType.NVarChar).Value = txtODPrism.Text;
        comm.Parameters.Add("@ODPrismDir1", SqlDbType.NVarChar).Value = cboODPrismDir1.SelectedItem.Text;
        comm.Parameters.Add("@ODPrism2", SqlDbType.NVarChar).Value = txtODPrism2.Text;
        comm.Parameters.Add("@ODPrismDir2", SqlDbType.NVarChar).Value = cboODPrismDir2.SelectedItem.Text;

        comm.Parameters.Add("@OSPrism", SqlDbType.NVarChar).Value = txtOSPrism.Text;
        comm.Parameters.Add("@OSPrismDir1", SqlDbType.NVarChar).Value = cboOSPrismDir1.SelectedItem.Text;
        comm.Parameters.Add("@OSPrism2", SqlDbType.NVarChar).Value = txtOSPrism2.Text;
        comm.Parameters.Add("@OSPrismDir2", SqlDbType.NVarChar).Value = cboOSPrismDir2.SelectedItem.Text;

        comm.Parameters.Add("@A", SqlDbType.NVarChar).Value = txtA.Text;
        comm.Parameters.Add("@B", SqlDbType.NVarChar).Value = txtB.Text;
        comm.Parameters.Add("@ED", SqlDbType.NVarChar).Value = txtED.Text;
        comm.Parameters.Add("@DBL", SqlDbType.NVarChar).Value = txtDBL.Text;

        comm.Parameters.Add("@MountType", SqlDbType.NVarChar).Value = rdoMountType.SelectedItem.Text;
        comm.Parameters.Add("@Thickness", SqlDbType.NVarChar).Value = rdoThickness.SelectedItem.Text;
        comm.Parameters.Add("@Tinting", SqlDbType.NVarChar).Value = rdoTinting.SelectedItem.Text;
        comm.Parameters.Add("@TintColor", SqlDbType.NVarChar).Value = cboTintColor.SelectedItem.Text;
        comm.Parameters.Add("@Transmission", SqlDbType.NVarChar).Value = cboTransmission.SelectedItem.Text;

        comm.Parameters.Add("@ARCoating", SqlDbType.NVarChar).Value = rdoARCoating.SelectedItem.Text;
        comm.Parameters.Add("@UVCoat", SqlDbType.NVarChar).Value = cbUVFilter.Checked;
        comm.Parameters.Add("@ScratchCoat", SqlDbType.NVarChar).Value = cbScratch.Checked;
        comm.Parameters.Add("@RollPolish", SqlDbType.NVarChar).Value = cbRollPolish.Checked;
        comm.Parameters.Add("@RushJob", SqlDbType.NVarChar).Value = cbRush.Checked;
        comm.Parameters.Add("@SpecialInstructions", SqlDbType.NVarChar).Value = txtSpecialInstructions.Text;


        comm.Parameters.Add("@Date", SqlDbType.DateTime).Value = DateTime.Now;
        try
        {
            conn.Open();
            comm.ExecuteNonQuery();
            lblError.Text = "Your order has been placed.";

            txtLastname.Text = "";
            txtFirstname.Text = "";

        }
        catch
        {
            lblError.Text = "An Error Occured Processing Your Order.  Please Try Again.";
        }
        finally
        {
            conn.Close();
        }
    }

Mark as answer posts that helped you.

- Reply
eyeguy1

Member

2 Points

61 Posts

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

May 08, 2012 07:50 PM|LINK

Nope. I changed it and it is still writing the first item in the second list and not the selected item...

Prev Next

First 1 2 3 4 5 6 7 8 Last

‹ Previous Thread|Next Thread ›

HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List. RSS

73 replies

bbcompent1

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

eyeguy1

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

eyeguy1

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

basheerkal

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

eyeguy1

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

bbcompent1

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

eyeguy1

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

bbcompent1

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

bbcompent1

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

eyeguy1

Re: HELP.. Filling Second DropDownList based on parameters of selection in another DropDown List...

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft