[2005] Insert Data From XML to Database

[killer7k]

Hi ,

I have an xml file & a DataGridView , textbox to run query
so i have the DataGridView filled by the xml file at the load using read xml

so now as i have the DataGridView filled by the data coming from the xml file
i want to run a query on it yes but the problem it say that the dataset dont know this table on the database..
so my question is :
-How i can copy the data from the xml file to the table on the database
so i can do query on it
-how i can do query without copying the xml file the table on the database

Thanks

[killer7k]

anyone got an idea ?
i just need how to copy XML file to database
which mean i have the XML file lie this

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <member>
    <Name>John</Name>
    <Email>[email protected]</Email>
    <Country>Australia </Country>
    </member>
</NewDataSet>

so it save to the database like this
Table Name : (member)
Field Name(Name,Email,Country) we can choose an type nvarchar as good
and the this table filled by the data coming from that xml file

The writeXml method yes right to the xml
the ReadXml file yes read the xml into the dataset but dont save it ..
i need to save it

if someone didnt undertand the situation i can explain more

Thanks

[killer7k]

anyone ?

Thanks