Click here to Skip to main content
15,914,943 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i need only three cells in a row in asp.net (C#)

my code is

C#
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>
Posted
Updated 16-Jun-10 23:42pm
v5

1 solution

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 />
 
Share this answer
 
Comments
jabregu 20-Jul-10 14:52pm    
Reason for my vote of 1
hasta el pincho
jabregu 20-Jul-10 14:52pm    
hasta el pincho

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900