0

apologies if this is in the wrong section,

the situation:

i have a drop down box with the values 1 - 10

<asp:DropDownList ID="DD" runat="server" Text='<%# Bind("DD") %>'>
                <asp:ListItem Value="1"></asp:ListItem>
                <asp:ListItem Value="2"></asp:ListItem>
                <asp:ListItem Value="3"></asp:ListItem>
                <asp:ListItem Value="4"></asp:ListItem>
                <asp:ListItem Value="5" Selected="True"></asp:ListItem>
                <asp:ListItem Value="6"></asp:ListItem>
                <asp:ListItem Value="7"></asp:ListItem>
                <asp:ListItem Value="8"></asp:ListItem>
                <asp:ListItem Value="9"></asp:ListItem>
                <asp:ListItem Value="10"></asp:ListItem>
            </asp:DropDownList>

i have a database table with four columns (Hours, EmployeeID, Rate, PayTotal)

<asp:GridView ID="GridView2" runat="server" DataSourceID="SqlDataSource2" 
            EmptyDataText="no data record." Width="748px" AllowPaging="True" 
            AllowSorting="True" CellPadding="4" ForeColor="#333333" GridLines="Both" 
            AutoGenerateColumns="False">
 
            <Columns>
                <asp:BoundField DataField="Hours" HeaderText="Hours" 
                    SortExpression="Hours" NullDisplayText="Null">
                    <ItemStyle BorderStyle="Dotted" />
                </asp:BoundField>
                <asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID"
                    SortExpression="EmployeeID" />
                <asp:BoundField DataField="Rate" HeaderText="Rate" 
                    SortExpression="Rate" />
                <asp:BoundField DataField="PayTotal" HeaderText="PayTotal" 
                    SortExpression="PayTotal" ReadOnly="True" />
                </Columns>
            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" HorizontalAlign="Center"/>
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Ad_newConnectionString1 %>" 
            ProviderName="<%$ ConnectionStrings:Ad_newConnectionString1.ProviderName %>" 
            SelectCommand="SELECT EmployeeID, Rate, DropDownList.DD AS Hours, Hours * Rate AS PayTotal FROM HumanResources.EmployeePayHistory"/>

sorry about all of the code, thought it would be best to stick everything in, in-case any one picks up on my problem.

the user will select the amount of hours worked from the drop down list
on doing this i want it to insert that value in to the column "Hours" and then once it has done that multiple it by the rate to give the 'PayTotal'
i can multiply the columns no problems but cannot for the life of me work out why it wont populate 'Hours' with the value from the drop down list


any help would be very handy as i have hit a brick wall on this i have tried a few things i found on google search but they all seem over complicated and don't seem to work unless i have missed some thing major

my whole code!

<%@ Import Namespace = "System.Data" %>
<%@ Import Namespace = "System.Data.SqlClient" %>
<%@ Page Language="C#" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._Default" %>
<!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>pay multiply</title>
</head>
<body onclick="return window_onclick()">
    <form id="form1" runat="server" title="welcome" onkeyup="return form1_onkeyup()">
    <div>
            <asp:TextBox ID="THours" runat="server" />
            <asp:CheckBox ID="CheckBox1" runat="server"/>
            <asp:Button ID="Button1" runat="server" Text="Button"  />
            <asp:DropDownList ID="DD" runat="server" Text='<%# Bind("DD") %>'>
                <asp:ListItem Value="1"></asp:ListItem>
                <asp:ListItem Value="2"></asp:ListItem>
                <asp:ListItem Value="3"></asp:ListItem>
                <asp:ListItem Value="4"></asp:ListItem>
                <asp:ListItem Value="5" Selected="True"></asp:ListItem>
                <asp:ListItem Value="6"></asp:ListItem>
                <asp:ListItem Value="7"></asp:ListItem>
                <asp:ListItem Value="8"></asp:ListItem>
                <asp:ListItem Value="9"></asp:ListItem>
                <asp:ListItem Value="10"></asp:ListItem>
            </asp:DropDownList>
    </div>
<div style="height: 371px; width: 746px;">
        <asp:GridView ID="GridView2" runat="server" DataSourceID="SqlDataSource2" 
            EmptyDataText="no data record." Width="748px" AllowPaging="True" 
            AllowSorting="True" CellPadding="4" ForeColor="#333333" GridLines="Both" 
            AutoGenerateColumns="False">
 
            <Columns>
                <asp:BoundField DataField="Hours" HeaderText="Hours" 
                    SortExpression="Hours" NullDisplayText="Null">
                    <ItemStyle BorderStyle="Dotted" />
                </asp:BoundField>
                <asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID"
                    SortExpression="EmployeeID" />
                <asp:BoundField DataField="Rate" HeaderText="Rate" 
                    SortExpression="Rate" />
                <asp:BoundField DataField="PayTotal" HeaderText="PayTotal" 
                    SortExpression="PayTotal" ReadOnly="True" />
                </Columns>
            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" HorizontalAlign="Center"/>
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Ad_newConnectionString1 %>" 
            ProviderName="<%$ ConnectionStrings:Ad_newConnectionString1.ProviderName %>" 
            SelectCommand="SELECT EmployeeID, Rate, DropDownList.DD AS Hours, Hours * Rate AS PayTotal FROM HumanResources.EmployeePayHistory"/>
<br />      
</div>
</form>
</body>
</html>
3
Contributors
3
Replies
10
Views
6 Years
Discussion Span
Last Post by danholding
0

danholding,

When you say it won't populate hours with the selection from the dropdown list, do you mean that it only populates the grid once, and wont do it again when it changes, or that it doesn't show any values in the hours column at all?

Edited by croker10: n/a

0

@ crocker10
i cannot get it to populate the hours column at all i have tried as great learner told me and changed it to

InsertCommand="INSERT DD.SelectedItem INTO Hours FROM  EmployeePayHistory"
UpdateCommand="UPDATE HumanResources.EmployeePayHistory SET Hours = Dropdownlist.SelectedItem"
/>

any ideas on why it would not populate i do not receive any errors from debugging?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.