How do I import xml data into a sql server database table in Windows form using c#?

I wanted to display Xml data into the sql server database table.

First, I displayed the Xml data using the console appl开发者_StackOverflow社区ication at run time, but now I want to store that XMl data into the database table.

How can I do this?

Himanshu Negi

Well, your XML is supposed to be a string (or it can easily be converted to).
So you can do this:

INSERT INTO your_table (your_col)
SELECT xml_str

I'm assuming you know how to connect to your db and run a SqlCommand after the connection is established...