嗨，我做一个WPF C＃应用程序的地方，我想保存到数据库中，通过storeprocedure。
该过程接受一个XML文档。我不知道如何保存XML数据，并保存它。

这里是我的代码，

public partial class MainWindow : Window

    {

        private XmlDocument saveXml;

        List<string> attribute;

        private String id, name, dep;

        private SqlConnection con;

        private SqlCommand com;

 

        public MainWindow()

        {

            con = new SqlConnection();

 

            con.ConnectionString = "Data Source=192.168.2.88; database=Student; User id=sa; Password=123456;";

 

            saveXml = new XmlDocument();

            attribute = new List<string>();

 

            InitializeComponent();

 

            saveXml.LoadXml("<root></root>");

 

            for (int i = 0; i < 4; i++)

            {

                id = i.ToString();

                name = "N" + i.ToString();

                dep = "D" + i.ToString();

 

                attribute.Add("id");

                attribute.Add("name");

                attribute.Add("dep");

 

                XmlParsingLibrary.XmlEngine.getInstance().writeNode(saveXml, "Student", "//Root", attribute,id,name, dep);

                attribute.Clear();

            }

 

            //MessageBox.Show(saveXml.OuterXml);

        }

 

        private void Button_Click(object sender, RoutedEventArgs e)

        {

            try

            {

                con.Open();

                com = new SqlCommand();

                com.Connection = con;

                com.CommandType = CommandType.StoredProcedure;

                com.CommandText = "ProcSave";

 

                SqlParameter inputUser2 = com.Parameters.AddWithValue("@xmlfile", saveXml);

                inputUser2.Direction = ParameterDirection.Input;

                com.ExecuteNonQuery();

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.Message);

            }

            finally

            {

                con.Close();

            }

        }

    }</string></string>

我的XML一样
{C}