transform SQL data into html table with asp

Question

I have unknown number of rows in my dabase with columns id and text. In my code I transform this data into list of object news with parameters id and text.

HTML

<div class="middleDiv" id="mid" runat="server">
</div>

Code:

List<news> news = loadNewsFroamDbs();
String html = "";
for (int i=0;i<news.Count; i++) {
String html1 = " <div class='big'>" +
                        "<div class='id'>" +
                            "<label>" + news.id + "</label>" +
                            "<label>id</label>" +
                        "</div>" +
                        "<div class='text'>" +
                            "<a href='newsDetail.aspx?id=" + news.id + "'>"
                            + news.text + "</a>" +
                        "</div></div>" 
html = html + html1;
mid.InnerHtml = html;
}

What component shoud I use when I want on my page something starting my delete() function? I can't use button+onClick method. Do I have to learn something about controllers?

Is there a reason you're not using something like a GridView that has methods like Delete and Update built in? — Melanie
– Melanie, Commented May 10, 2013 at 18:37
GridView is just only table. This code is example, in real I have 10 atributes instead of 2 and I want specific formating I can do with divs. — Eleer
– Eleer, Commented May 10, 2013 at 18:42
If I am right RazorEngine is somethink like MVC? On one hand I have to rework all my project, on the other hand this frameworks giving me more options...am I still right? — Eleer
– Eleer, Commented May 10, 2013 at 19:56
@user2270693 Yes it is used in MVC, but you can reference that single DLL in your project and use it as shown in its homepage. It is a templating engine. You can even use it in console application. — I4V
– I4V, Commented May 10, 2013 at 20:11

Geeky Guy · Accepted Answer · 2013-05-10 21:19:00Z

1

Melanie is right. You should use a GridView, if you're going to use the HTML table element.

If you're not going to use a table, then use a DataList. That's probably what you want. If that still doesn't suit you, look up the other data controls you can use (check the left pane on the DataList page).

Edit: Why can't you use buttons for deletion? I don't see a reason not to, and AFAIK all data controls will allow you to use buttons for creation, deletion and edition.

answered May 10, 2013 at 21:19

Geeky Guy

9,3895 gold badges46 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marcianin · Accepted Answer · 2013-05-10 23:34:25Z

I agree with everyone here and you should use a GridView instead, now take a look at this quick example to see how to use it, you can pretty much format the table to look any way you want (and you dont really have to type all the code yourself VS will do a lot for you)

.ASPX

<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" 
            GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" 
                    ShowSelectButton="True" />
            </Columns>
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F5F7FB" />
            <SortedAscendingHeaderStyle BackColor="#6D95E1" />
            <SortedDescendingCellStyle BackColor="#E9EBEF" />
            <SortedDescendingHeaderStyle BackColor="#4870BE" />
        </asp:GridView>

.CS

public class News
    {
        public int id { get; set; }
        public string title { get; set; }
        public string content { get; set; }
        //as many properties as you want
    }
    public partial class bindGridviewToList : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            News n1 = new News() { id = 1, content = "content", title = "title" };
            News n2 = new News() { id = 2, content = "content", title = "title" };
            News n3 = new News() { id = 3, content = "content", title = "title" };

            List<News> newsList = new List<News>();

            newsList.Add(n1); newsList.Add(n2); newsList.Add(n3);

            GridView1.DataSource = newsList;
            GridView1.DataBind();
        }
    }

Run this sample and you will see how easy it is to use GridView

Collectives™ on Stack Overflow

transform SQL data into html table with asp

2 Answers 2

Comments

.ASPX

.CS

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

.ASPX

.CS

Comments

Your Answer

Sign up or log in

Post as a guest

Related