Query on XML

Hi,

1) Can I do select, update and insertion queries on XML file
2) Can I do update query on dataset instead using of loop

Thank's
Alexei

originsnone
If you're dealing with that amount of records you want an actual database, any reason you can't use one (Have you tried the SQL Flat-file database in VS2005 or SQL Server Express , both are in Beta, if you need it right now think about MySQL or another database server).
_cham
Hi,

It's slowly... I am working with 175,000 records at least....
On some reason it can be milions of records....

If can somebody tell me how to same big amout of records (milions) to database in 30 seconds (+/-)

Thank's
Alexei
Timmy Lajaunie
I agree with the other answer. If you have so many records then go with a database such as SQL Server Express.

Regards,
Vikram
la
Hi,

My problem was to put there records to database (took about 5 minuts) and creating xml file takes 2 seconds.

I found the bulk insertion command of MSDE/SQL server. I have put the data to text file with delimiter and use bulk insert command (with lock table parameter) to upload there data to database. It raised the process to 8 seconds.

Thank's
Alexei
Big Ticket

Hi,

Its not possible out of the box, but you can take a look at the following link:

http://www.codeproject.com/dotnet/XmlDb.asp

Regards,

Vikram
Query on XML