我想以表格形式从数据库中检索数据 [英] i want to retrieve data from database in table form

问题描述

我在asp.net(C#)中连续只需要三个单元格

我的代码是

i need only three cells in a row in asp.net (C#)

my code is

protected void Page_Load(object sender, EventArgs e)
   {
       int i = 0;
       string sb = Session["subcat"].ToString();
       string cstring;
       cstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
                 Server.MapPath("~/") + "db1.mdb";
       //specify the connection
       conn.ConnectionString = cstring;
       conn.Open();
       //create sqlcommand
       OleDbCommand cmd = conn.CreateCommand();
       cmd.CommandText  = "select sphoto ,itemname from itemsale where itemsubcat="
                          + "'" + sb + "'";

       OleDbDataReader dr = cmd.ExecuteReader();
       Table tc = new Table();

       while (dr.Read())
       {
           //for (int rno = 0; rno <= 2; rno++)
           //{
               TableRow tr = new TableRow();
               for (int cno = 0; cno <= 2; cno++)
               {
                   TableCell td     = new TableCell();
                   Label lb         = new Label();
                   lb.Text          = "<img src=" + dr.GetString(0) + ">";
                   HyperLink href   = new HyperLink();
                   href.Text        = dr.GetString(1);
                   href.NavigateUrl = "view1.aspx";
                   tr.Cells.Add(td);
                   td.Controls.Add(lb);
                   td.Controls.Add(new LiteralControl("<br>"));
                   td.Controls.Add(href);
               }
               tc.Rows.Add(tr);
           //}
               Panel1.Controls.Add(tc);
       }
   }</img>

推荐答案

也许您需要在while循环之后编写Panel1.Controls.Add(tc);并在while循环中添加测试.就像

maybe you need to write Panel1.Controls.Add(tc); after while-loop and add test in while-loop. like

<br />
while(dr.Read() && count < 3 )<br />
{<br />
...<br />
count++;<br />
}<br />
//CLOSE YOUR STUFF HERE<br />
Panel1.Controls.Add(tc);<br />

这篇关于我想以表格形式从数据库中检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！