I am attempting to use a repeater to obtain multiple columns of data by year within an existing repeater by topic

I am attempting to use a repeater to obtain multiple columns of data by year within an existing repeater by topic.

The number of years is variable so cannot be done as a static row.

This is a sample of the existing report and I would like to add a repeater to duplicate the Average column for each year in the list of years available.

•  This Preceptorship enabled me to
      Average
Obtain and record a thorough and reliable history.      
Obtain and record a thorough and reliable physical exam.      
Develop a problem list.      
Develop a list of possible etiologies (differential diagnosis.)      
Order appropriate studies.      
Recommend rational therapy.      
Communicate with health team.      
Increase proficiency in technical procedures.      
Increase knowledge of patient problems in primary care.      
Average of Above Ratings      

I’ve been experimenting and just can’t get the syntax right to generate the multiple columns.

This is the first few rows of code before adding a repeater.

                  <div class="indent" ">
                  <li class="label" style="margin-top:20px;">This Preceptorship enabled me to:</li>

<asp:Table ID="Table2" GridLines="Both" runat="server" >
         <asp:TableHeaderRow ID="TableHeaderRow1"  runat="server" >
                  <asp:TableHeaderCell ID="TableHeaderCell1" ColumnSpan="30"   HorizontalAlign="Left"  runat="server" TabIndex="0"
                 Text="" Wrap="True" />
                  <asp:TableHeaderCell ID="TableHeaderCell2" ColumnSpan="10"   HorizontalAlign="Right"  runat="server" TabIndex="1"
                 Text="Average" Wrap="True" />
                         
         </asp:TableHeaderRow >

         <asp:TableRow ID="TableRow41"  runat="server" >
                 <asp:TableCell ID="TableCell3" colspan="30"   HorizontalAlign="Left"  runat="server"  
                 Text="Obtain and record a thorough and reliable physical history." Wrap="False" />
                  <asp:TableCell ID="TableCell4"  width="4"    HorizontalAlign="Right"  runat="server"  aria-readonly="true" >
                 <input type = "text" value='<%#DataBinder.Eval(Container.DataItem, "objHistory")%>'" Wrap="False" >
                          </asp:TableCell>
         </asp:TableRow >

         <asp:TableRow ID="TableRow42"  runat="server" >
                 <asp:TableCell ID="TableCell5" colspan="30"   HorizontalAlign="Left"  runat="server"  
                 Text="Obtain and record a thorough and reliable physical exam." Wrap="False" />
                  <asp:TableCell ID="TableCell6"  width="4"    HorizontalAlign="Right"  runat="server"  aria-readonly="true" >
                 <input type = "text" value='<%#DataBinder.Eval(Container.DataItem, "objExam")%>'" Wrap="False" >
                          </asp:TableCell>
         </asp:TableRow >

         <asp:TableRow ID="TableRow3"  runat="server" >
                 <asp:TableCell ID="TableCell15" colspan="30"   HorizontalAlign="Left"  runat="server"  
                  Text="Develop a problem list." Wrap="False" />
                  <asp:TableCell ID="TableCell16"  width="4"    HorizontalAlign="Right"  runat="server"  aria-readonly="true" >
                 <input type = "text" value='<%#DataBinder.Eval(Container.DataItem, "objList")%>'" Wrap="False" >
                          </asp:TableCell>
         </asp:TableRow >

 
         <asp:TableRow ID="TableRow4"  runat="server" >
                 <asp:TableCell ID="TableCell22" colspan="30"   HorizontalAlign="Left"  runat="server"  
                 Text="Develop a list of possible etiologies (differential diagnosis.)" Wrap="False" />
                  <asp:TableCell ID="TableCell23"  width="4"    HorizontalAlign="Right"  runat="server"  aria-readonly="true" >
                 <input type = "text" value='<%#DataBinder.Eval(Container.DataItem, "objEtiologies")%>'" Wrap="False" >
                          </asp:TableCell>
         </asp:TableRow >
jrwalker1048Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bob LearnedCommented:
I don't see a Repeater, I see a <table> element.  If you have a table layout, did you try binding to a GridView?
0
jrwalker1048Author Commented:
I don’t have a repeater in the example because none of my attempts worked so I just included the base code for information on how to add the repeater for multiple columns.

If there is another way to add a variable number of columns that would be fine but every page may have a different number of columns so I thought a repeater would work.

thanks
0
jrwalker1048Author Commented:
Do you have sample code I can try?

Thank you for your expertise. Truly appreciated!
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Bob LearnedCommented:
With ASP.NET and the GridView, the binding depends on the type of data.

Here are some examples:

ASP.NET Quickstart Tutorials
http://quickstarts.asp.net/QuickStartv20/aspnet/doc/ctrlref/data/gridview.aspx

GridView + SqlDataSource Example:

  <asp:GridView ID="GridView1" DataSourceID="SqlDataSource1" AutoGenerateColumns="False"
      runat="server">
      <Columns>
        <asp:BoundField HeaderText="ID" DataField="au_id" ReadOnly="true" />
        <asp:BoundField HeaderText="Last Name" DataField="au_lname" />
        <asp:BoundField HeaderText="First Name" DataField="au_fname" />
        <asp:BoundField HeaderText="Phone" DataField="phone" />
        <asp:BoundField HeaderText="Address" DataField="address" />
        <asp:BoundField HeaderText="City" DataField="city" />
        <asp:BoundField HeaderText="State" DataField="state" />
        <asp:BoundField HeaderText="Zip Code" DataField="zip" />
        <asp:CheckBoxField HeaderText="Contract" DataField="contract" />
      </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
      SelectCommand="SELECT [au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract] FROM [authors]"
      ConnectionString="<%$ ConnectionStrings:Pubs %>" />

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
I've requested that this question be closed as follows:

Accepted answer: 500 points for Bob Learned (TheLearnedOne)'s comment #a40364788

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
jrwalker1048Author Commented:
Thank you for your assistance
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.