farshad Posted November 11, 2003 Posted November 11, 2003 Can someone please point me out to where I can get good examples on how to transfer the data from .xml file into a table in database. Thanks Quote Farshad
AlexCode Posted November 11, 2003 Posted November 11, 2003 There's no big deal... You have to use DataSets :D and the Read/WriteXml commands... Try to populate a dataset from a DataBase and Write the XML to a file with DataSet1.WriteXML("...") This way you'll see the XML structure and mess around with it a bit! Google returned me this... http://www.informit.com/content/index.asp?product_id=%7BD314FA5F-8114-4764-B6C9-0E7E12607CD3%7D Alex :D Quote Software bugs are impossible to detect by anybody except the end user.
farshad Posted November 11, 2003 Author Posted November 11, 2003 my dataset is not being populated from a database. It is being populated from a .xml file I can place the data from .xmml into a dataset but still can not transfer the dataset to a table in database. Is there a way to just transfer the whole xml data into the table in database? thanks Quote Farshad
Mothra Posted November 13, 2003 Posted November 13, 2003 If you're getting your data into a dataset, there should be no reason you can't get it into a database. You just have to set up a connection to the db, set up a dataadapter and use the adapter's .Update command. Of course, you'll have to make sure the data types you're using match those in the db as well. Do you have any code you can post? It may give us a better idea of whats wrong. Quote Being smarter than you look is always better than looking smarter than you are.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.