Wrox Programmer Forums
|
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 20th, 2006, 06:13 PM
Registered User
 
Join Date: Mar 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to m_t_clayton Send a message via Yahoo to m_t_clayton
Default Data Entry from Repeater

I have a Student_ID(TextBox)and Repeater with Activity_ID(Label) and Score (DropDownList). The repeater show the labels and dropdowns as they should look. But after data entry is done I need it to input 34 seperate records into a with the Student_ID always the same and Activity_ID(is incremented 1 to 34) and the Score selected dropdown. I don't know if need to add these to collection or can use FormParameters. Current code listed below:

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    <asp:DropDownList ID="DDL_Collection" runat="server" DataSourceID="SqlDS_Collection"
        DataTextField="Collection_Period" DataValueField="Collection_ID">
    </asp:DropDownList><br />
        <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDS_Activities">
        <ItemTemplate>
            <table runat=server>
                <tr>
                    <td width=100>
                        <%#Eval("ActivityDescription")%>
                    </td>
                    <td>
                        <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDS_Score" DataTextField="Score"
                            DataValueField="Scored_ID">
                        </asp:DropDownList>
                    </td>
                </tr>
            </table>

        </ItemTemplate>
    </asp:Repeater>
    <asp:SqlDataSource ID="SqlDS_Activities" runat="server" ConnectionString="<%$ ConnectionStrings:WorkSamplingConnectionString1 %>"
        SelectCommand="SELECT [ActivityDescription], [Activities_ID] FROM [tblActivities]">
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDS_Score" runat="server" ConnectionString="<%$ ConnectionStrings:WorkSamplingConnectionString1 %>"
        SelectCommand="SELECT [Scored_ID], [Score] FROM [tblScore]">
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDS_Collection" runat="server" ConnectionString="<%$ ConnectionStrings:WorkSamplingConnectionString1 %>"
        SelectCommand="SELECT Collection_ID, Collection_Period FROM tblCollection WHERE (DataEntryAvailable = 1)">
    </asp:SqlDataSource>
</asp:Content>





Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to manage data entry and updates th Bjay Pro VB Databases 0 July 22nd, 2007 04:49 PM
Automating Data Entry - subform sbraudrick Access VBA 4 March 22nd, 2007 06:22 AM
Formatting Data Entry in forms aRtware Access 5 May 12th, 2006 09:16 AM
Data entry from email SiliconFuRy PHP Databases 4 December 17th, 2004 09:40 AM
error in data entry vickyj SQL Server 2000 6 September 13th, 2004 10:02 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.