写了一个关于将XML文件导入数据库的程序(C#,sql server)

<?xml version="1.0" standalone="yes"?>
 2 <NewDataSet>
 3   <Table>
 4     <Id>1</Id>
 5     <Names>dawei</Names>
 6     <Sex>男</Sex>
 7     <Age>21</Age>
 8   </Table>
 9   <Table>
10     <Id>2</Id>
11     <Names>dain</Names>
12     <Sex>女</Sex>
13     <Age>20</Age>
14   </Table>
15   <Table>
16     <Id>3</Id>
17     <Names>xiyue/Names>
18     <Sex>女</Sex>
19     <Age>20</Age>
20   </Table>
21   <Table>
22     <Id>4</Id>
23     <Names>chenxin</Names>
24     <Sex>女</Sex>
25     <Age>16</Age>
26   </Table>
27   <Table>
28     <Id>5</Id>
29     <Names>kuai</Names>
30     <Sex>女</Sex>
31     <Age>20</Age>
32   </Table>
33 </NewDataSet>

下面是将数据库中的数据保存问XML格式

string con = "server=.; database = db_stu;Trusted_Connection = true";
            string cmdText = "select * from student";
            DataSet ds = new DataSet();
            using(SqlDataAdapter sda = new SqlDataAdapter(cmdText,con))
            {
                sda.Fill(ds);
            }
            ds.WriteXml("a.xml");
            Console.WriteLine("Execute success");
            Console.ReadKey();

string con = "server=.; database = db_stu;Trusted_Connection = true";
            SqlConnection sc = new SqlConnection(con);
            SqlDataAdapter da = new SqlDataAdapter();
            string cmdText = string.Format(@"insert into student(Names,Sex,Age) 
                                                values(@Names,@sex,@Age)");
            SqlCommand cmd = new SqlCommand(cmdText,sc);
            try
            {
                
                sc.Open();
                DataSet dt = new DataSet();
                dt.ReadXml("a.xml");
                cmd.Parameters.Add("@Names",SqlDbType.VarChar,20,"Names");
                cmd.Parameters.Add("@sex",SqlDbType.VarChar,10,"Sex");
                cmd.Parameters.Add("@Age",SqlDbType.Int,10,"Age");
                da.InsertCommand = cmd;
                da.Update(dt.Tables[0]);
                Console.WriteLine("Execute success!");
                Console.ReadKey();
            }catch(Exception ex)
            {
                Console.WriteLine(ex.Message);
                Console.ReadKey();
            }
            finally
            {
                sc.Close();
            }