N-level brushless New Linkage menu

Usage:

SqlConnection cnn;
SqlCommand cmd;


Cnn = new SqlConnection (SqlHelper. connstr ());
Cmd = cnn. CreateCommand ();

Cnn. Open ();
If (! Page. IsPostBack)
{
SqlDataReader dr;

Cmd. CommandText = "SELECT MenuID, MenuName FROM Menu where ParentID = 0 and MenuType = 'product '";
Dr = cmd. ExecuteReader ();
DdlPublishers. DataSource = dr;
DdlPublishers. DataTextField = "MenuName ";
DdlPublishers. DataValueField = "MenuID ";
DdlPublishers. DataBind ();
Dr. Close ();
}

Cmd. CommandText = "SELECT MenuID, ParentID, MenuName from Menu where ParentID> 0 and MenuType = 'product '";
SqlDataAdapter da = new SqlDataAdapter (cmd );
DataSet ds = new DataSet ("Titles ");
Da. Fill (ds, "titles ");

Array Data;
Data = Array. CreateInstance (typeof (object), 1, 3); // 1 control the number of subsequent menus.
Data. SetValue ("ddlTitles", 0, 0 );
Data. SetValue (ds, 0, 1 );
Data. SetValue ("titles", 0, 2 );
DdlTitles. TableName = "titles ";

DdlPublishers. SlaveData = Data;

Cnn. Close ();
}