Show Drop Down In .Net MVC by XML file

Hi Yash,

do refer below article

https://www.c-sharpcorner.com/uploadfile/b19d5a/dropdownlist-data-binding-from-xml-file-in-Asp-Net/

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 C14.95Widget D34.99Gadget Z69.95Gizmo 12339.99Thingamajig12.49Doodad 50059.95Gadget A122.99Widget Z244.99Gizmo 78949.95Gadget 123X55.99Widget D427.95Thingamabob 2.019.99Gadget XYZ64.99Widget E17.95Thingy 529.99Gadget AB54.95Widget LMN39.99Gizmo 24649.95Gadget 789Q59.99Widget F122.99Gadget RTX44.99Gizmo 11149.95Thingy 1034.99Widget Z927.95Thingamajig 3.024.99Alovera299.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

adjust the according to your requirement!