Create LI from C# code behind into an ASPX page

Question

I have an ASPX page with a asp:BulletedList control which I would like to populate from code-behind using C#.

Here is my SQL Table (TBook):

LOCATION
New Rochelle
Purchase
Rye
Scarsdale
White Plains
Yonkers

My ASP page looks like this so far:


        
            LOCATIONS

The C# code so far looks like this:

string connectionString="Data Source=myServBook;InitialCatalog=MyDB; UserID=srvdb;" + 
                        "Password=servdbtest0980";

    protected void Page_Load(object sender, EventArgs e)
    {
        /*using(SqlConnection sqlConnection=new SqlConnection(connectionString))
{
     string insertStatement="SELECT FROM [MyDB].[dbo].[TBook]";
     SqlCommand sqlCommand=new SqlCommand(insertStatement,sqlConnection);
     /* ADD THE LI HERE */
     /*sqlConnection.Open();
     sqlCommand.ExecuteNonQuery();
}*/
    }

I have the following code which adds the LI based on DataSource:

DataTable dt = getData(); //Insert your datasource here

    foreach(DataRow row in dt.Rows){
        HtmlGenericControl li = new HtmlGenericControl("li");
        li.Attributes.Add("data-trait-id", row["TraitID"].ToString());

        HtmlAnchor a = new HtmlAnchor();
        a.Attributes.Add("data-trait-id", row["TraitID"].ToString());

        HtmlGenericControl span1 = new HtmlGenericControl("span");
        span1.Attributes.Add("class", "name");
        span1.InnerText = row["Name"].ToString();
        a.Controls.Add(span1);

        HtmlGenericControl span2 = new HtmlGenericControl("span");
        span2.Attributes.Add("class", "count");
        span2.InnerText = row["Count"].ToString();
        a.Controls.Add(span2);

        li.Controls.Add(a);
        ulSpecialty_selector.Controls.Add(li);
    }

The above code uses a DataSource. How can I modify it so it adds the number of LI based on the number of rows in the table, similar to the commented out HTML code in my ASPX page?

Link = "#"
Name = Table Row Value
Count = Table Row Number

Chris · Accepted Answer

Here is what I came up with for you, the only problem is that you wanted a number on the right as well, this solution won't do that. However you can use a repeater, that will allow you to have your number to the right. Anyhow this is some idea to get you through till someone gives a better solution...

        cblTest.DataSource = "YourDataTableOrDataset";
        cblTest.DataValueField = "YourIDColumnFromYourTable";
        cblTest.DataTextField = "YourColumnName";
        cblTest.RepeatDirection = RepeatDirection.Horizontal;//Option of vertical
        cblTest.RepeatColumns = 5; //or however many you need i.e how many columns you want to go across before repeating
        cblTest.CssClass = "YourCSSClass"; //for styling the checkboxlist
        cblTest.DataBind();

Create LI from C# code behind into an ASPX page

Answers (1)

Related Questions