Click here to Skip to main content
11,634,827 members (67,185 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: C++ C C# ASP ASP.NET Javascript HTML , +
// con.Open();
        SqlDataAdapter dadCategories = new SqlDataAdapter("SELECT ID,Name FROM Category order by Name", con);
        SqlDataAdapter dadSubCat = new SqlDataAdapter("SELECT BD,ID,BName FROM Brand order by BName", con);
        // Add the DataTables to the DataSet
        DataSet dsCat = new DataSet();
        using (con)
            dadCategories.Fill(dsCat, "Category");
            dadSubCat.Fill(dsCat, "Brand");
        // Add a DataRelation
        dsCat.Relations.Add("Children", dsCat.Tables["Category"].Columns["ID"], dsCat.Tables["Brand"].Columns["ID"]);
        // Add the Category nodes
        int count = 0;
        foreach (DataRow categoryRow in dsCat.Tables["Category"].Rows)
            MenuItem mNode = new MenuItem(Convert.ToString(categoryRow["Name"]), "", "", "~/item.aspx?CatID=" + Convert.ToString(categoryRow["ID"]), "_parent");
            // Get matching Sub Category
            DataRow[] subCatRows = categoryRow.GetChildRows("Children");
            foreach (DataRow row in subCatRows)
                string subCatName = Convert.ToString(row["BName"]);
                MenuItem subCatItems = new MenuItem(subCatName, "", "", "~/item.aspx?CatID=" + Convert.ToString(row["ID"]) + "&BID=" + Convert.ToString(row["BD"]), "_parent");
            count = count + 1;

Non-invocable member 'System.Web.UI.WebControls.Menu.Items' cannot be used like a method

please help me
Posted 26-Dec-12 18:11pm
Edited 26-Dec-12 18:19pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

This is C#. you index items with [] not ().


That's a guess, it would help if you told us what line has the error.
sreeCoderMan at 27-Dec-12 1:56am
can you explain 3 table relationship
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Syntax Error :
Menu1.Items(count).ChildItems.Add(subCatItems); // You can't put int value as a parameter of Items

see MSDN[^]

so it could be like this,

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 8,736
1 Sergey Alexandrovich Kryukov 8,419
2 Mika Wendelius 6,845
3 F-ES Sitecore 2,354
4 Suvendu Shekhar Giri 2,205

Advertise | Privacy | Mobile
Web02 | 2.8.150728.1 | Last Updated 27 Dec 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100