How can i make dynamically sliding menu

Ekrem Tapan

11y913.NET

hello every one,

how can i make dynamically sliding menu like that below link

http://codepen.io/jasonhowmans/pen/dykhL

and my schema like that this

Create table tblMenu

(

Id int primary key identity,

MenuText nvarchar(30),

ParentId int foreign key references tblMenu(Id),

Active bit

)

Insert into tblMenu values('USA', NULL, 1)

Insert into tblMenu values('India', NULL, 1)

Insert into tblMenu values('UK', NULL, 1)

Insert into tblMenu values('Australia', NULL, 1)

Insert into tblMenu values('Virginia', 1, 1)

Insert into tblMenu values('Maryland', 1, 1)

Insert into tblMenu values('AP', 2, 1)

Insert into tblMenu values('MP', 2, 1)

Insert into tblMenu values('Karnataka', 2, 1)

Insert into tblMenu values('Bangalore', 9, 1)

Insert into tblMenu values('Mangalore', 9, 1)

Insert into tblMenu values('Mysore', 9, 0)

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ekrem Tapan11y ago
Sujeet Suman im completed,
public string GetConnectionStrings()
{
string ConStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
return ConStr;
}
public DataTable SelectDataTable(String Sql)
{
DataTable dt = new DataTable();
SqlConnection oSqlConnection = new SqlConnection(GetConnectionStrings());
try
{
oSqlConnection.Open();
SqlDataAdapter sqlda = new SqlDataAdapter(Sql, GetConnectionStrings());
sqlda.Fill(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
oSqlConnection.Close();
oSqlConnection.Dispose();
}
return dt;
}
private string GenerateMenu(DataRow[] drParentMenu, DataTable oDataTable, StringBuilder oStringBuilder)
{
oStringBuilder.AppendLine("
"); if (drParentMenu.Length > 0)
{
foreach (DataRow dr in drParentMenu)
{
string MenuURL = dr["URL"].ToString();
string MenuName = dr["Name"].ToString();
string line = String.Format(@"
{1}", MenuURL, MenuName);
oStringBuilder.Append(line);
string MenuID = dr["MenuID"].ToString();
string ParentID = dr["ParentID"].ToString();
DataRow[] subMenu = oDataTable.Select(String.Format("ParentID = {0}", MenuID));
if (subMenu.Length > 0 && !MenuID.Equals(ParentID))
{
var subMenuBuilder = new StringBuilder();
oStringBuilder.Append(GenerateMenu(subMenu, oDataTable, subMenuBuilder));
} oStringBuilder.Append("

}

oStringBuilder.Append("");

return oStringBuilder.ToString();

}

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

DataTable oDataTable = new DataTable();

oDataTable = SelectDataTable("SELECT MenuID, ParentID, Name, URL FROM Menus");

DataRow[] drParentMenu = oDataTable.Select("ParentID = 0");

var oStringBuilder = new StringBuilder();

string MenuList = GenerateMenu(drParentMenu, oDataTable, oStringBuilder);

Literal1.Text = MenuList;

}

front end

Ekrem Tapan11y ago

Sujeet Suman hi ,

i mean just i wanna use thats schema then create dynamically sliding menu like that on this link http://codepen.io/jasonhowmans/pen/dykhL

i wantto use C# create a dynamical sliding menu app use this http://codepen.io/jasonhowmans/pen/dykhL

Sujeet Suman11y ago

Tapan can you please explain in details that in which kind of application you want to create menu?