Question about datalist in asp.net

Question

0.00/5 (No votes)

See more:

hello can any one tell me that ..!
I retrieve a single column data from sql server horizontaly in a row.
i wana do that after five values in a row it's automatically created second(another) row for 6,7,8,9,10 value.
and then third row for 11,12,13,14,15 values. and up to so on..
please give me it's example code . ..
the code is given below :

ASP.NET

<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource3" 
                        RepeatDirection="Horizontal" CssClass="cll_bg" ShowFooter="False" ShowHeader="False" GridLines="Both">
                        <itemtemplate>
                        <table style="height:48px">
                            <tr><td align="center" title="days here" style="height:18px; width:16px"><%# Eval("days") %></td></tr>
                        </table>
                        </itemtemplate>
                    
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:BRIDGES_DBConnectionString %>" 
                        SelectCommand="SELECT [month] FROM [tbl_calendar_days]">

Posted 31-Aug-12 6:44am

Member 8911636

Updated 31-Aug-12 8:11am

luisnike19

v3

Add a Solution

Comments

[no name] 31-Aug-12 12:47pm

You are going to have to be more specific with what it is that you want to do, including the code that you have tried but is not working like you would like it to work.

Member 8911636 31-Aug-12 13:34pm

i have given it's code...
i wana get it in an other row after 5 values

Prabhakaran Soundarapandian 31-Aug-12 12:56pm

Can you improve your question...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

compninja25 · Answer 1 · 2012-08-31T16:40:00

You might be able to pull this one off with a GridView control directly, or make a dataTable dynamically and then set the table as the gridviews data source. This would be the general idea...

declare a dataTable
declare a data row

while (reading Database)
{
     for (int i=0; i < 5; i++)
     {
        //add cell to dataRow until we hit 5
     }
     
     //add the data row to the dataTable and start over until end of database.

}

There are a lot of examples floating around on dynamically adding rows to a data table out there that might be able to help