hello how can import data from a xml file to insert them in my database by vb.net/asp.net?? thank you
do you want to import the entire file of just specific data?
Derek - Using VS 2008 99% of the time and VS 2003 1% of the time Please Help Us To Save Ana ● Helpful Links: DNR TV | Awesome site for tips | Using ADO.NET to work with Excel | Xml Namespace 2.0 Framework Changes|Ultra High Security Password Generator | Mendhak's ADO.NET Tutorial ● Code Bank: Random Password Generator | Generic DbProviderFactory Access ● Site Work: Bottle Run Xtreme | Spaids Racing.com Company I work for - CSSI WHEN POSTING PLEASE INDICATE VERSION Please use vbcode tags or code tags when posting code [highlight=vb]ALL your code goes here[/highlight] or [code]ALL your code goes here[/code] If my post helped you in anyway... please be kind and give me some ratings
all data in the file
does the file have the same structure as the table(s) ie file Code: <root> <TableName1> <Col1>data1</Col1> <Col2>data2</Col2> etc. </TableName2> <TableName1> <Col1>data1</Col1> <Col2>data2</Col2> etc. </TableName2> </root> in the database Table1 Col1|Col2|etc. Table2 Col1|Col2|etc.
<root> <TableName1> <Col1>data1</Col1> <Col2>data2</Col2> etc. </TableName2> <TableName1> <Col1>data1</Col1> <Col2>data2</Col2> etc. </TableName2> </root>
ok thank you i try in this way bye
Forum Rules
Reply With Quote
