4
Answers

How to prepare the XML file by using Database server

SIVA

SIVA

13y
1.7k
1
Hi All,
I have database with some table like
DNo DName Location Employees
10 IT Hyd 15 
20 Sales Bangalore 29
----------------With some more records----------------

My requirement is now i want to send this datasource to somewhere in the form of XML file.
So We can't prepare again the XML file for those records
Is there any alternate solutions or tool to generate the XML file by using Database/Table

Can you tell me the process....
Answers (4)
0
Jaganathan Bantheswaran
NA 21.9k 2.2m 11y
Provide some code. where you want to do this? At what stage you are now?

Meanwhile,

You can add properties dynamically in two ways,

1. using ExpandoObject

   var dynamicObject = new ExpandoObject();
   dynamicObject.YourPro1 = "Your Value 1";
   dynamicObject.YourPro1 = 1234;

2. using Dictionary

    public class MyClass
   {
       public string Template { get; set; }
       public string Term { get; set; }
       public Dictionary<string, string> Properties{ get; private set; }

      public MyClass()
      {
          Properties= new Dictionary<string, string>();
      }

      public void AddProperty(string key, string value)
      {
             Properties.Add(key, value);
      }
   }

    // to be used like this:
    MyClass instance = new MyClass();
    instance.AddProperty("Email", "test@example.com");
    instance.AddProperty("Phone", "976856734");

3. using Reflection Emit

    Please read here with Example.