Hi,

Thank you for posting your question here.
I tried this and I got the same result as you got. We are looking into this and will let you know as soon as we find out why.

Thanks.

Alright... Maybe I am a little dense. This is what I have attempted to do. It is probably easiest to just show you the code snippet.

sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["TFGecommerceConnectionString"].ConnectionString);
sqlConnection.Open();
SqlCommand selectAllIndustries = new SqlCommand("GetAllIndustires", sqlConnection);
selectAllIndustries.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(selectAllIndustries);
da.Fill(ds);
SlideMenu1.DataSource = ds.Tables[0];
SlideMenu1.DataFields = "Name"; //Have also tried @Name
SlideMenu1.DataBind();

The code for the slideMenu looks like this.

<eo:MenuItem Text-Html="ind" NormalStyle-CssText="background-color:silver; "SelectedStyle-CssText="background-color:#0000c0;">
<SubMenu>
<Bindings>
<eo:DataBinding DataField="Name" Property="Text" />
</Bindings>
</SubMenu>
</eo:MenuItem>

I am totally missing something however as far as I can tell I have done things right. You said in both cases the key is to define the hierarchical structure of the data but in this case there is only one level so I am not sure what you mean by that.

Thanks for your help on this.

Hi

I have looked at the link you showed me. I understand what you are talking about however I still haven't been able to come up with a working solution.

how about an example that shows how to connect to a SQL database and create the dynamic slidmenu? I am a little frustrated with the help file at this point cause it isn't really a complete working example (no code behind page or anything that shows the creation of a datasource) and unless I am nuts I can't seem to find an example in the live demo that connects to a SQL database and creates a dynamic menu.


uhg....

Hi all,

Well I finally got this thing to work. I looked at the example of the regular menu, sure they work mostly the same however I was stuck creating the sub menus. finally it dawned on me. I figured I would post this so that if anyone else has this problem they can see what to do. I always hate half finished threads cause someone figures it out and never says anything about the solution.

Cool!

protected void Page_Load(object sender, EventArgs e)
{
//first off create a new MenuItem.
EO.Web.MenuItem testMenuItem = new EO.Web.MenuItem("test");
//add that item to your slideMenu - you have to do this in order
//to assign it a dataSource.
SlideMenu1.Items.Add(testMenuItem);

//create the dataTable - you can do this any way you see fit,
//manually from a DB whatever.
DataTable mainTable = CreateDataTable(); //Just used to one from the live demo...

//assign the dataSource to the menuItem
testMenuItem.SubMenu.DataSource = mainTable;
//Set the DataFields
testMenuItem.SubMenu.DataFields = "City";

//Create a DataBinding, this is where I got the big clue on how to
//do this. - If you look at the examples where they have just a menu
//you only see how to add to the main menu. However once I saw this
//I figured that you could create an instance of subMenu just like you
//create an instance of DataBinding.
//
//Sure enough - you can, and once you do you can add a binding just like
//you could add a binding to the main slideMenu itself.
//
//Sounds easy once you know what you are doing...
EO.Web.DataBinding binding = new EO.Web.DataBinding();
binding.DataField = "WebSite";
binding.Property = "NavigateUrl";

testMenuItem.SubMenu.Bindings.Add(binding);
testMenuItem.SubMenu.DataBind();
}