programmatically creating a table in dotnet

20 Mar 2006 6:18 AM

Priya

Hi,

I need to create a temp table in my asp.net web services program. I
have an xml file of the format

<uom_masters>
    <uom_code>varchar</uom_code>
    <uom_description>varchar</uom_description>
    <uom_tolerance>money</uom_tolerance>
</uom_masters>

I need to read the fields along with the datatypes an create a table
with all these fileds in the program itself. Does anyone have an idea
how to do it. Thanks in advance

20 Mar 2006 7:21 AM

Cerebrus

Hi,

To fill a DataSet with data from XML, simply use the DataSet.ReadXml()
method. You can use the XmlReadMode parameter to fine tune your
requirements.

For more information : (MSDN help)

ms-help://MS.VSCC/MS.MSDNVS/cpguide/html/cpconloadingdatasetfromxml.htm

Check out this link for more information related to what you're doing :

http://msdn2.microsoft.com/en-us/library/s5xy331f.aspx

Hope this helps,

Regards,

Cerebrus.

21 Mar 2006 5:04 AM

Priya

Hi,

Thanks for the help The link was useful. I have resolved my problem of
creating temp table

20 Mar 2006 7:38 AM

Cor Ligthert [MVP]

Priya,

Don't look that this is a windowsforms sample, creating the datatable is the
same.

http://www.vb-tips.com/default.aspx?ID=30d9d2fd-9f10-4928-b7c8-1def3152436f

I hope this helps,

Cor

Show quoteHide quote

"Priya" <priyavaithianat***@gmail.com> schreef in bericht
news:1142835513.030412.266670@j33g2000cwa.googlegroups.com...
> Hi,
>
> I need to create a temp table in my asp.net web services program. I
> have an xml file of the format
>
> <uom_masters>
> <uom_code>varchar</uom_code>
> <uom_description>varchar</uom_description>
> <uom_tolerance>money</uom_tolerance>
> </uom_masters>
>
> I need to read the fields along with the datatypes an create a table
> with all these fileds in the program itself. Does anyone have an idea
> how to do it. Thanks in advance
>