Show Drop Down In .Net MVC by XML file

Question

I want fill dependent dropdown by XML file which be create(data by sql server) on session intialization.

Vishal Yelve · Answer

Hi Yash do refer below article https://www.c-sharpcorner.com/uploadfile/b19d5a/dropdownlist-data-binding-from-xml-file-in-Asp-Net/

Tahir Ansari · Answer

Hello Yash Singh Try below sample code: Convert the query result into XML format using SQL Server's FOR XML clause SELECT ProductName Price FROM products FOR XML AUTO ELEMENTS; --output--- Widget C 14.95 Widget D 34.99 Gadget Z 69.95 Gizmo 123 39.99 Thingamajig 12.49 Doodad 500 59.95 Gadget A1 22.99 Widget Z2 44.99 Gizmo 789 49.95 Gadget 123X 55.99 Widget D4 27.95 Thingamabob 2.0 19.99 Gadget XYZ 64.99 Widget E 17.95 Thingy 5 29.99 Gadget AB 54.95 Widget LMN 39.99 Gizmo 246 49.95 Gadget 789Q 59.99 Widget F1 22.99 Gadget RTX 44.99 Gizmo 111 49.95 Thingy 10 34.99 Widget Z9 27.95 Thingamajig 3.0 24.99 Alovera 299.00 Save the XML result into an XML file using C# code or any other preferred method. 2. Load XML Data on Session Initialization: using System.IO; using System.Xml.Linq; // During session initialization string xmlFilePath = path/to/your/xml/file.xml; Dictionary > dependentData = new Dictionary >(); if (File.Exists(xmlFilePath)) { XDocument xmlDoc = XDocument.Load(xmlFilePath); foreach (var element in xmlDoc.Root.Elements()) { string parentValue = element.Attribute(Column1).Value; List childValues = element.Elements(Column2).Select(e => e.Value).ToList(); dependentData[parentValue] = childValues; } } Html + Javascript code Select Parent Option Select Dependent Option // JavaScript/jQuery code $(document).ready(function () { // Function to populate the dependent dropdown function populateDependentDropdown(parentValue) { // Get child values for the selected parent from the data structure (e.g. session) var childValues = /* Retrieve child values for parentValue from your data structure */; // Clear existing options and populate the dependent dropdown var dependentDropdown = $(#dependentDropdown); dependentDropdown.empty(); $.each(childValues function (index value) { dependentDropdown.append($(' ').text(value).attr('value' value)); }); } // Event handler for parent dropdown selection change $(#parentDropdown).on(change function () { var selectedParentValue = $(this).val(); if (selectedParentValue !== ) { // Populate the dependent dropdown when the parent dropdown selection changes populateDependentDropdown(selectedParentValue); } }); }); adjust the according to your requirement!