protected void Page_Load(object sender, EventArgs e)
{
string constr = System.Configuration.ConfigurationManager.ConnectionStrings["test1ConStr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select ProdID from Product";
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
//For Table
Table1.Rows.Clear();
TableRow tr = new TableRow();
Table1.Rows.Add(tr);
int Counter = 1;
while (reader.Read())
{
int Prodid = 0;
if (!reader.IsDBNull(0))
{
Prodid = reader.GetInt32(0);
}
Show_productUserControl sp = (ASP.show_productusercontrol_ascx)Page.LoadControl("~/Show_productUserControl");
sp.ID = "ProdSuc" + Prodid.ToString();
sp.ProdID = Prodid;
sp.SetData();
//...........cells
TableCell tc = new TableCell();
tr.Cells.Add(tc);
tr.Controls.Add(sp);
Counter++;
if (Counter > 4)
{
TableRow trx = new TableRow();
Table1.Rows.Add(trx);
tr = trx;
Counter = 1;
}
}
reader.Close();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
string constr = System.Configuration.ConfigurationManager.ConnectionStrings["test1ConStr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select ProdID from Product";
//----------------------
if (Request.QueryString["cat"] != null)
{
if (Request.QueryString["cat"] != "")
{
int catid = 0;
if (int.TryParse(Request.QueryString["cat"], out catid))
{
cmd.CommandText = "select ProdID from Product where catid=@catid";
cmd.Parameters.Add("@catid", SqlDbType.Int, 4).Value = catid;
}
}
}
//---------------------------
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
//For Table
Table1.Rows.Clear();
TableRow tr = new TableRow();
Table1.Rows.Add(tr);
int Counter = 1;
while (reader.Read())
{
int Prodid = 0;
if (!reader.IsDBNull(0))
{
Prodid = reader.GetInt32(0);
}
Show_productUserControl sp = (ASP.show_productusercontrol_ascx)Page.LoadControl("~/Show_productUserControl.ascx");
sp.ID = "Psuc" + Prodid.ToString();
sp.ProdID = Prodid;
sp.SetData();
//...........cells
TableCell tc = new TableCell();
tr.Cells.Add(tc);
tc.Controls.Add(sp);
Counter++;
if (Counter > 3)
{
TableRow trx = new TableRow();
Table1.Rows.Add(trx);
tr = trx;
Counter = 1;
}
}
reader.Close();
con.Close();
}