sql server - Hierarchical Database Driven Menu in MVC -


I use the code below as an HTMLHelper that receives data from the database and displays a menu Gives the end to that. This is quite straightforward because you can see though, what will happen if you have a database table using the adjacent model of the hierarchy eg ID / ParentID, order ID. It's easy to see what's going on, but requiring recursion to get this data properly. Is C # recursive function acceptable? If such a person can help me? Expected output is similar to this .. 

  & lt; Ul & gt; & Lt; Li & gt; Item 1 & lt; Ul & gt; & Lt; Li & gt; SubItem1 & lt; / Li & gt; & Lt; / Ul & gt; & Lt; / Li & gt; & Lt; / Ul & gt;

There is now a hierarchy datatype in SQL 2008, so I'm not sure that things will help it?

I also have to decide which items are run in the menu, to enable them to select a list of items that go to the menu and then select these items and select their status in the hierarchy. There will also be a way to do it

Am I asking too much, am I sure that this should be a normal scenario?

This is my HTMLHelper code if someone wants to use it ...

Static String Menu (HtmlHelper Assistant, int MenuCat) {string menuHTML = "& Lt; ul id = \ "menu \" & gt; "; Var route = helper VisualEntax Request TEXT Root data; String currentPageName = route.GetRequiredString ("id"); DB DB = DB CreteDBee (); // var results = p to db.WebPages where p.CategoryID ==9p; Var results = p; db.WebPages choose p; Foreign currency (different items in result) {if (item.Name == currentPageName) {menu html + "\ n \ t
  • + Helper.ActionLink (item.Name," description "," dinner ", New {id = item.ID}, new {@class = "selected"}) + "& lt; / Li & gt; ";} Else {menuHTML +" "\ n \ t & li; li & gt;" + Helper.ActionLink (item.Name, "Description", "Dinner", new {id = item.ID }, Blank) + "& lt; / li & gt;"; }} Menu HTML + = "\ n & gt; \ n"; Return menu html; } I will do two things here: do not disturb yourself in presenting: Use jQuery If you find hundreds of links to Google "jquery menu"

    Next, place an ordering logic on your app, you do not need DB to do this because it increases the cycle and (from what I have read) is not very efficient. This is a simple reference logic in which With self-referencing involvement, Linq is perfect for that.

    Leave it on jQuery, ADN is good for you to go without code-coding HTML code :)


    • Comments

    Post a Comment

    Popular posts from this blog

    python - Overriding the save method in Django ModelForm -

    I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
    Read more

    html - CSS autoheight, but fit content to height of div -

    I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
    Read more

    qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

    I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
    Read more