Read or write xml to and from database

[ajijacobm]

hi,
Please show me how to write data from a table in a database to xml and loading or inserting xml data to database(reverse process).
I don't have any idea of this problems.
I have Tried my level best,but failed to do so..
please show me how to copy data from 1 database to another databse ..
Anyone please Help me:'(
Anyway ThAnkS in Advance...:$

[DdoubleD]

Hello ajijcobm, I am bored so I decided to look up this subject (cause I have never personally done it before). Anyway, here are some links I thought might get you started:

XML and Database Mapping in .NET
An XML Database Schema And Data Editor
Create Data Classes

Hope that gets you started.

Cheers!

[kvprajapati]

Use DataSet class,

// Populate DataSet using Database
    SqlDataAdapter adp = new SqlDataAdapter("select * from tableName", "your_conn_str");
     DataSet ds=new DataSet("MyDB");
     adp.Fill(ds,"tableName");
 
     // Write Data into XML
        ds.WriteXml("file.xml");

// Load(Read) XML data

          DataSet ds=new DataSet();
          ds.ReadXml("file.xml");
          DataTable dt=ds.Tables["tableName"];
          dt.Rows.Add("val1","val2"); // Adding row

// Update database
           SqlDataAdapter adp=new SqlDataAdapter("select * from tableName","your_conn_str");
           SqlCommandBuilder cb = new SqlCommandBuilder(adp);
           DataSet ds = new DataSet();
           ds.ReadXml("file.xml");
           DataTable dt = ds.Tables["tableName"];
           dt.Rows.Add("val1", "val2"); // Adding row
           adp.Update(ds, "tableName");

[bbauraj]

we read and write xml by using dataset and using the readxml and writexml
see this helpful link related to Read or write xml to and from database :)

[Mansoor_3]

gr8

[JobPencil]

Try This Article
Read and Write in XML

Thanks