How to Create XML file of Database in C Sharp

How to Create XML file of Database in C Sharp

To create XML file of Database we have to call WriteXml() function of Data Set.

Example
string strConnection = 'Server=abc\\SQLEXPRESs;Database=Employee;Trusted_Connection=True';
            SqlConnection con = new SqlConnection(strConnection);
//creating new connection to database Employee
            con.Open();
//opening connection
SqlDataAdapter da = new SqlDataAdapter('select * from employee', con);
//assigning data to DataAdapter according to the query
            DataSet ds = new DataSet();
            da.Fill(ds, 'Employee');
//filling dataset.
            ds.WriteXml('C:\\dataEmployee.xml');
//writing XML file of name ‘dataEmployee.xml’ of database
Screen shot

How to Create XML file of Database in C Sharp

Last updated:8/5/2020 6:07:47 AM
Anonymous User

Anonymous User

I am a content writter !

2 Comments

Leave Comment