Generate the XML file from access query or any dataset value by using xml schema in c#.net windows application

Question

0.00/5 (No votes)

See more:

SQL

OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\test.mdb;"); con.Open(); OleDbCommand cmd = new OleDbCommand("SELECT [add].[stname], [add].[conno] FROM add;", con); OleDbDataAdapter oDA = new OleDbDataAdapter(cmd); DataSet ds1 = new DataSet(); oDA.Fill(ds1); ds1.ReadXmlSchema("Sample.xsd");

here after i got error like type validation schema is not declared

i have one xml schema and access database i need to generate the xml from more than one table fields in this case i can use the queries but after read the queries i displayed that in grid view then i need to generate the xml file which are shown in the gridview using xml schema i have no idea about this.., if anyone have such idea about this means just help me.., thanx in advance..,

Posted 18-May-14 14:39pm

Mohammed Ikbal Abdul Salam

Add a Solution

Comments

syed shanu 18-May-14 21:33pm

Do you want to create a XML file from Dataset?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

syed shanu · Accepted Answer · 2014-05-18T15:49:00

I have make a simple C# Program for you to
1) create a XML file from Dataset
2) To read the XMLSCHEMA to dataset.

// Place 2 Buttons and one Datagireview in your form :

C#

// Declare a Datatable and Function to fill data to datatable : 

 DataTable dt;
        private void fillRows(int pID, string pName, int pPrice)
        {
            DataRow dr;
            dr = dt.NewRow();
            dr["Product_ID"] = pID;
            dr["Product_Name"] = pName;
            dr["product_Price"] = pPrice;
            dt.Rows.Add(dr);
        } 

// In Button1_Click :  fill the dataset and Datagridview and create XML file 

 private void button1_Click(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            dt = new DataTable();
            dt.Columns.Add(new DataColumn("Product_ID", Type.GetType("System.Int32")));
            dt.Columns.Add(new DataColumn("Product_Name", Type.GetType("System.String")));
            dt.Columns.Add(new DataColumn("product_Price", Type.GetType("System.Int32")));
            fillRows(1, "product1", 1111);
            fillRows(2, "product2", 2222);
            fillRows(3, "product3", 3333);
            fillRows(4, "product4", 4444);
            ds.Tables.Add(dt);
            ds.Tables[0].TableName = "product";
            ds.WriteXml(@"D:\Product.xml");
            MessageBox.Show("Done");
            dataGridView1.DataSource = ds.Tables[0];
            
        }
// In Button2_Click :  Read the XMLSchema to dataset : 

  private void button2_Click(object sender, EventArgs e)
        {
            DataSet thisDataSet = new DataSet();
            // Set the file path and name. Modify this for your purposes. 
            string filename = @"D:\Product.xml";
            // Create a FileStream object with the file path and name.
            System.IO.FileStream stream = new System.IO.FileStream
                (filename, System.IO.FileMode.Open);
            // Create a new XmlTextReader object with the FileStream.
            System.Xml.XmlTextReader xmlReader =
                new System.Xml.XmlTextReader(stream);
            // Read the schema into the DataSet and close the reader.
            thisDataSet.ReadXmlSchema(xmlReader);
            xmlReader.Close();
            dataGridView1.DataSource = thisDataSet.Tables[0];

        }