how to display table rows in html table using asp.net

Question

I am using mysql database. in my mysql table, columns are c_name, c_number, c_mail and c_address. I want to show this table in html table. My asp.net code is below.

        dbConnection.Open();
        String str = "select c_name, c_number, c_mail, c_address from contacts where user_id = "+user_id+"";
        MySqlCommand cmd = new MySqlCommand(str, dbConnection);
        cmd.ExecuteNonQuery();
        MySqlDataReader mdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        while (mdr.Read())
        {
            cname = mdr.GetValue(0).ToString();
        }

Please Help me. How can i do this?

Sam · Accepted Answer · 2014-12-11 05:33:51Z

0

The easiest way is to use a GridView.

Add a GridView to your page and in your code behind just assign the DataReader you already have to this GridView's DataSource property.

dbConnection.Open();
        String str = "select c_name, c_number, c_mail, c_address from contacts where user_id = "+user_id+"";
        MySqlCommand cmd = new MySqlCommand(str, dbConnection);
        cmd.ExecuteNonQuery();
        MySqlDataReader mdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);


GridView1.DataSource = MySqlDataReader;
GridView1.DataBind();

answered Dec 11, 2014 at 5:33

Sam

2,9251 gold badge17 silver badges28 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:05:52Z

0

User Gridview or Repeater instead.

Some examples of repeater
http://www.sitepoint.com/asp-net-repeater-control/

If you still want to use HtmlTable then you can use the classes which are available in asp.net.

Table tbl = new Table();
TableRow tr = null;
TableCell cell = null;

.......
.......
panel.Controls.Add(tbl);

You need to use the following namespace using System.Web.UI.HtmlControls;

Some similar question on SO

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Dec 11, 2014 at 5:33

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

Collectives™ on Stack Overflow

how to display table rows in html table using asp.net

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related