Ver Mensaje Individual
  #2 (permalink)  
Antiguo 31/12/2010, 02:43
abcdefg
 
Fecha de Ingreso: marzo-2009
Mensajes: 79
Antigüedad: 15 años, 2 meses
Puntos: 0
Respuesta: Acordion dinamico alimentado desde base de datos

Saludos, yo logre crear este, me genera los panes bien y la info se muestra perfecto, el problema es que no me expanden los paneles, podrias colaborarme por favor:

<asp:Accordion ID="Accordion1" runat="server" TransitionDuration="200" FramesPerSecond="200" FadeTransitions="true"
RequireOpenedPane="false" OnItemDataBound="Accordion1_ItemDataBound" ContentCssClass="acc-content" HeaderCssClass="acc-header"
HeaderSelectedCssClass="acc-selected">
<HeaderTemplate>
<%#DataBinder.Eval(Container.DataItem,"Title") %>
</HeaderTemplate>
<ContentTemplate>
<asp:HiddenField ID="IDVulnerability" runat="server" Value='<%#DataBinder.Eval(Container.DataItem,"ID Vulnerability") %>' />
<asp:HiddenField ID="IDServer" runat="server" Value='<%#DataBinder.Eval(Container.DataItem,"ID Vulnerability") %>' />
<table>
<tr>
<td><asp:Label ID="LblDesciption" runat="server" Font-Bold="true" Text="Descripción: "></asp:Label></td>
<td><asp:Label ID="LblDescriptiontxt" runat="server" Font-Bold="false" Text=<%#DataBinder.Eval(Container.DataItem,"Descri ption") %>></asp:Label></td>
</tr>
<tr>
<td><asp:Label ID="LblCVE" runat="server" Font-Bold="true" Text="CVE: "></asp:Label></td>
<td><asp:Label ID="LblCVEtxt" runat="server" Font-Bold="false" Text=<%#DataBinder.Eval(Container.DataItem,"CVE") %>></asp:Label></td>
</tr>
<tr>
<td><asp:Label ID="LblProbability" runat="server" Font-Bold="true" Text="Probabilidad: "></asp:Label></td>
<td><asp:Label ID="LblProbalilitytxt" runat="server" Font-Bold="false" Text=<%#DataBinder.Eval(Container.DataItem,"Probab ility") %>>></asp:Label></td>
</tr>
<tr>
<td><asp:Label ID="LblRisk" runat="server" Font-Bold="true" Text="Riesgo: "></asp:Label></td>
<td><asp:Label ID="LblRisktxt" runat="server" Font-Bold="false" Text=<%#DataBinder.Eval(Container.DataItem,"Risk") %>></asp:Label></td>
</tr>
<tr>
<td><asp:Label ID="LblRecomendation" runat="server" Font-Bold="true" Text="Recomendación: "></asp:Label></td>
<td><asp:Label ID="LblRecomendationtxt" runat="server" Font-Bold="false" Text=<%#DataBinder.Eval(Container.DataItem,"Recome ndation") %>></asp:Label></td>
</tr>
<tr>
<td><asp:Label ID="LblComments" runat="server" Font-Bold="true" Text="Comentarios: "></asp:Label></td>
<td><asp:Label ID="LblCommentstxt" runat="server" Font-Bold="false" Text=<%#DataBinder.Eval(Container.DataItem,"Commen ts") %>></asp:Label></td>
</tr>
</table>
</ContentTemplate>
</asp:Accordion>

************************************************** **********
if (!IsPostBack)
{
getCategories();
}

public void getCategories()
{
SqlConnection sqlConn = new SqlConnection(conString);
sqlConn.Open();
int Idser;
Idser = int.Parse(this.Request.QueryString["ID"]);
SqlCommand sqlSelect = new SqlCommand("SELECT ServerVulnera.[ID Server], ServerVulnera.[ID Vulnerability], ServerVulnera.Comments, ServerVulnera.Solve, vulnerabilities.Title, vulnerabilities.Description, vulnerabilities.CVE, vulnerabilities.Probability, vulnerabilities.Risk, vulnerabilities.Recomendation FROM [ServerVulnera] JOIN vulnerabilities ON ServerVulnera.[ID Vulnerability] = vulnerabilities.ID WHERE [ID Server]='"+Idser+"';", sqlConn);
sqlSelect.CommandType = System.Data.CommandType.Text;
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlSelect);
DataSet myDataset = new DataSet();
sqlAdapter.Fill(myDataset);
sqlConn.Close();

Accordion1.DataSource = myDataset.Tables[0].DefaultView;
Accordion1.DataBind();

}
protected void Accordion1_ItemDataBound(object sender, AjaxControlToolkit.AccordionItemEventArgs e)
{
if (e.ItemType == AjaxControlToolkit.AccordionItemType.Content)
{
SqlConnection sqlConn = new SqlConnection(conString);
sqlConn.Open();
int setid;
setid = int.Parse(this.Request.QueryString["ID"]);
SqlCommand sqlSelect = new SqlCommand("SELECT ServerVulnera.[ID Server], ServerVulnera.[ID Vulnerability], ServerVulnera.Comments, ServerVulnera.Solve, vulnerabilities.Title, vulnerabilities.Description, vulnerabilities.CVE, vulnerabilities.Probability, vulnerabilities.Risk, vulnerabilities.Recomendation FROM [ServerVulnera] JOIN vulnerabilities ON ServerVulnera.[ID Vulnerability] = vulnerabilities.ID WHERE [ID Server]='"+setid+"';", sqlConn);
sqlSelect.CommandType = System.Data.CommandType.Text;
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlSelect);
DataSet myDataset = new DataSet();
sqlAdapter.Fill(myDataset);
sqlConn.Close();
}

}