Create dynamic accordion pane and bind with varbinary data

create dynamic accordion pane and bind with varbinary data

Design page for VS2008

<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">

</asp:ToolkitScriptManager>

<asp:Accordion ID="Dynamic" runat="server" SelectedIndex="0" HeaderCssClass="headerAccordion" ContentCssClass="contentAccordion">

</asp:Accordion>

Design page for VS2010

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<asp:Accordion ID="Dynamic" runat="server" SelectedIndex="0" HeaderCssClass="headerAccordion" ContentCssClass="contentAccordion">

</asp:Accordion>

Add below line for css within <title></title>

(you will get at attachment)

Code Behind

Retrieve value and put at datatable like below

string sql1 = "select * from Admin_Package_Details where Pak_Type='" + b + "'";
SqlConnection con = new SqlConnection(GetConnectionString());
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

Now create dynamic accordion pane based on value with pane title

int i = 0;
for(i=0;i<dt.rows.count;i++)
{
//create pane with unique id
AjaxControlToolkit.AccordionPane pn;
pn = new AjaxControlToolkit.AccordionPane();
pn.ID = "Pane" + i;
//create title and bind
Label lbTitle;
lbTitle = new Label();
for (int p = 0; p < dt.Rows.Count; p++)
{
lbTitle.Text = b.ToString() + " " + "(" + dt.Rows[p][2].ToString() + "Days Package)";
}
//now add title at pane
pn.HeaderContainer.Controls.Add(lbTitle);
//add pane at accordion
Dynamic.Panes.Add(pn);
i++;
}

Now if you have to bind varbinary data at dynamic accordion then do like below.

dt.Columns.Add("PackageDescriptionNew");
foreach (DataRow dr in dt.Rows)
{
if (dr != null)
{
byte[] byt = (byte[])dr[3];
string str;
System.Text.ASCIIEncoding enc = new System.Text.ASCIIEncoding();
str = enc.GetString(byt);
dr[4] = str;
}
}

My varbinary content was at 4^th column so dr[3] and I create one extra (column(dt.Columns.Add("PackageDescriptionNew");) which is dr[4].

Now create dynamic table where you can bind this value, like below.

(Namespace using System.Web.UI.HtmlControls;)

HtmlTable table1 = new HtmlTable();
HtmlTableRow row;
HtmlTableCell cell;
cell = new HtmlTableCell();
row = new HtmlTableRow();
cell.InnerHtml = dt.Rows[0][4].ToString();
row.Cells.Add(cell);
table1.Rows.Add(row);

Now add this table at accordion pane like below.

pn.ContentContainer.Controls.Add(table1);

Now you can add print button like below.

Button print;
print = new Button();
print.Text = "Print";
print.Attributes.Add("onclick", "return printing()");
pn.ContentContainer.Controls.Add(print);

Java script you have to add

Now you can add link button with querystring like below

string a = lbTitle.Text;
string url = "querystring.aspx?";
url += "Item=" + a.ToString();
LinkButton lk;
lk=new LinkButton();
lk.Text="Booking";
lk.PostBackUrl = url;

add link button at accordion pane like below

pn.ContentContainer.Controls.Add(lk);