Web-Design

Unbegrenzte Kategorielogik Asp.Net

DB TABLE SCRIPT:

CREATE TABLE TBL_KATEGORI
(
ID INT IDENTITY (1.1) NICHT NULL,

KAT_ID INT NULL,

KAT_ISMI NVARCHAR (50) NULL
)

HTML-CODES:

<% @ Page Language = “C #” AutoEventWireup = “true” CodeFile = “Default.aspx.cs” Inherits = “_ Default”%>

<! DOCTYPE html PUBLIC “- // W3C // DTD XHTML 1.0 Transitional // DE” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<html xmlns = “http://www.w3.org/1999/xhtml”>

<head runat = “server”>

<title> Unbegrenzte Kategorie | ul, li </ title>

</ Head>

<KÖRPER>

<form id = “form1” runat = “server”>

<Div>

<ul id = “Menu1” runat = “server”> </ ul>

</ Div>

</ Form>

</ Body>

</ Html>

C # -CODES:

using System.Collections.Generic;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Web.UI.HtmlControls;

using System.Configuration;

öffentliche Teilklasse _Default: System.Web.UI.Page
{
DataSet ds = new DataSet ();

protected void Page Load (Objektabsender, EventArgs e)
{
fill ();
}}

private Lücke füllen ()
{
In SqlDataAdapter = new SqlDataAdapter (“SELECT * FROM TBL_KATEGORILER”, ConfigurationManager.ConnectionStrings [“Connect”]. ConnectionString);

da.fill (ds);

DataRow [] mainCategories = ds.Tables [0] .Select (“KAT_ID = 0”);

foreach (DataRow mainCategory in mainCategories)
{

HtmlGenericControl li = neues HtmlGenericControl (“li”);

li.Controls.Add (neues LiteralControl (“<a href='<%#Eval(‘ID’)%> ‘>” + mainCategory [“CAT_NAME”). ToString () + “</a>”));

menu1.controls.add (li);

Untermenü (Convert.ToInt32 (Anakategor von [“ID”]));

}}
}}

privates ungültiges Altmenü (int categoryId)
{

DataRow [] category = ds.Tables [0] .Select (“KAT_ID =” + categoryId);

if (Kategorien.Länge == 0)
{

}}
sonst
{

Menu1.Controls.Add (neues LiteralControl (“<ul>”));

foreach (DataRow-Kategorie in Kategorien)
{

HtmlGenericControl li1 = neues HtmlGenericControl (“li”);

li1.Controls.Add (neues LiteralControl (“<a href=’#’>” + category [“CAT_NAME”). ToString () + “</a>”));

menu1.controls.add (LI1);

Untermenü (Convert.ToInt32 (Kategorie [“ID”]));
}}

Menu1.Controls.Add (neues LiteralControl (“</ ul>”));
}}
}}
}}