Load XML File Data

[sonia.sardana]

Is It Possible to Load XML File data into Adapter???

protected void Page_Load(object sender, EventArgs e)
    {
        
        DataSet ds1 = new DataSet();
        DataSet ds2 = new DataSet();

        if (!IsPostBack)
        {
            
            ds1.ReadXml("C:\\Users\\indel_intern96\\Desktop\\SONIA FOLDER\\sonia1.xml");
            OracleDataAdapter da = new OracleDataAdapter();
            da.Fill(ds2, 0, 4,"Table1");
            GridView1.DataSource = ds1;
            GridView1.DataBind();
            GridView2.DataSource = ds2;
            GridView2.DataBind(); 
        }
    }

Cz in my above when i executed,I m getting the error -- VALUE cannot be null. Cz da is null. SO plz help me out.


If Not Possible to Load XML file Data into Adapter,then wats the alternative way to do??

[gep13]

Hey,

Part of the problem is that you are using ds2 to Fill da, but you are loading the XML into ds1.

I don't think this is what you intended to do, is it?

Gary

[sonia.sardana]

Hi Gep,Wat exactly I want is Suppose in ds1,I have 10 Rows,In Ds2 I want to copy the First 5 Rows.I want to do just dat!! But Not able to find the solution.

[gep13]

Ok, but this is different from what you have talked about above.

Your last post would indicate that you already have the DataTables populated. Once you have, then it is a simple matter of copying the DataRows between DataTables.

Have a look here:

http://support.microsoft.com/kb/308909

For information on how this can be achieved.

Gary

[sonia.sardana]

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DataSet ds1 = new DataSet();
            DataSet ds3 = new DataSet();
            DataTable table_org = new DataTable();
            DataTable table_copy = new DataTable();

            ds1.ReadXml("C:\\Users\\indel_intern96\\Desktop\\SONIA FOLDER\\sonia1.xml");
            OracleDataAdapter da = new OracleDataAdapter();

            table_org = ds1.Tables[0];
            int iRowsCount;
            iRowsCount = table_copy.Rows.Count;

            for (int i = 0; i < table_org.Rows.Count; i++)
            {
                table_copy.ImportRow(table_org.Rows[i]);
            }
            iRowsCount = table_copy.Rows.Count;
            ds3.Tables.Add(table_copy);
        }

Earlier in iRowsCount=0, but after executin the for Loop,in iRowsCount=4. Rows are copied but not the row data.

            for (int i = 0; i < table_org.Rows.Count; i++)
            {
                table_copy.ImportRow(table_org.Rows[i]);
            }

In fig,You can see what table_copy contains!!

[gep13]

Hey,

Have you set a breakpoint on this line:

table_copy.ImportRow(table_org.Rows[i]);

Does it ever get hit?

Gary

[sonia.sardana]

hi Gep,Yes the statement is hit. Statement hit,dats y the 4 rows are inserted but only the rows are copied not the data.

[gep13]

Hey,

The documentation for that method:

http://msdn.microsoft.com/en-us/libr...importrow.aspx

Suggests that it should pull across the current values of the row as well. I will do some digging and see what I can come up with.

Gary

[danasegarane]

Try this one...

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DataSet ds1 = new DataSet();
            DataSet ds3 = new DataSet();
            DataTable table_org ;
            DataTable table_copy ;

            ds1.ReadXml("C:\\Users\\indel_intern96\\Desktop\\SONIA FOLDER\\sonia1.xml");
            
	//Copy the structure to the second table
            table_copy =table_org.clone();

            table_org = ds1.Tables[0];
            int iRowsCount;
            iRowsCount = table_copy.Rows.Count;

            for (int i = 0; i < table_org.Rows.Count; i++)
            {
                table_copy.ImportRow(table_org.Rows[i]);
               //Or use this method
             //  table_copy.rows.add(table_org.Rows[i].toItemArray());
            }
            iRowsCount = table_copy.Rows.Count;
            ds3.Tables.Add(table_copy);
        }