Question i need to add xml to database

[gavaghan]

here is the xml layout

<type id="34">
−
<all>
<volume>244193068038.00</volume>
<avg>10.03</avg>
<max>19999.00</max>
<min>0.17</min>
<stddev>312.02</stddev>
<median>2.20</median>
</all>
−
<buy>
<volume>141014690673.00</volume>
<avg>1.80</avg>
<max>3.00</max>
<min>0.17</min>
<stddev>0.45</stddev>
<median>1.83</median>
</buy>
−
<sell>
<volume>103178377365.00</volume>
<avg>2.62</avg>
<max>19999.00</max>
<min>1.39</min>
<stddev>361.75</stddev>
<median>2.30</median>
</sell>
</type>

i have it loading into 4 datagridviews any ideas on how i can get this to work?

 

[MattP]

Are you wanting to load it into a sql column of type xml? Are you wanting to parse it in some way and then insert it? What do the DataGridViews have to do with this question?

 

[gavaghan]

i want to all of it in to a sql database .. the datagridview don't have anything to do with it in less it can help get it in to a database

 

[MattP]

i want to all of it in to a sql database

How do you want it in a database? Xml Column? Parsed with each value in its own column?

 

[gavaghan]

form what i can tell Xml Column should be fine . i want to take it in to 3 tables one sell , buy , and all

 

[gavaghan]

ok got it done now i just have to have a datagridview save into a database?