I think this question have been asked many times already(I my self asked once),But there is a new problem which i am facing.I am creating an array of buttons onclick of another button in my application.Number of buttons created will depend upon values which i get from database and values which i get from database depends on a session value which i pass in the query.My code is as below..
Code:
protected void attributes()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());
SqlCommand cmd = new SqlCommand("select attributesequenceNumber as attsno,ProductCode as pcode, P26 as '" + 26 + "',P28 as '" + 28 + "',P30 as '" + 30 + "',P32 as '" + 32 + "',P34 as '"+34+"',P36 as '"+36+"',P38 as '"+38+"',P40 as '"+40+"',P42 as '"+42+"',SHXS as XS,SHS as S,SHM as M,SHL as L,SHXL as XL,SHXXL as XXL from tblattribute where ProductCode='" + Session["ImgProdCode"] + "'", con);
//SqlCommand cmd = new SqlCommand("select Col.value('local-name(.)', 'varchar(Max)') as ColName from (select * from tblattribute where ProductCode ='"+Session["ImgProdCode"]+"' for xml path(''), type) as T(XMLCol) cross apply T.XMLCol.nodes('*') as n(Col) where Col.value('.', 'varchar(1)') = 1 " , con);
try
{
con.Open();
cmd.ExecuteNonQuery();
DataTable dtble = new DataTable();
SqlDataAdapter dap = new SqlDataAdapter(cmd);
dap.Fill(dtble);
if (dtble.Rows.Count > 0)
{
result = dtble.Columns.Cast<DataColumn>()
.Where(c => c.ColumnName != "pcode" && c.ColumnName != "attsno")
.Where(c => dtble.Rows[0][c].ToString() == "1")
.Select(c => c.ColumnName)
.ToList();
res = result.Count;
lbl = new Button[res];
for(i=0; i<result.Count; i++)
{
lbl[i] = new Button();
lbl[i].Text = result[i];
lbl[i].ID = "btn" + i.ToString();
lbl[i].Width = 30;
lbl[i].Click+=new EventHandler(lbl_click);
lbl[i].CssClass = "label";
div1.Controls.Add(lbl[i]);
}
}
}
catch
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
protected void lbl_click(object sender, EventArgs e)
{
Button lbl = sender as Button;
lbl.CssClass = "label1";
}
The above method attributes() will be called on a button click,and the session value will also be generated on buttonclick.On research i came to know that the creation of dynamic buttons should be done in page_init event but i cannot do it here.Please help to solve this issue..