xml导入

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Xml;


namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
            scsb.ConnectionString = "Data Source=70EU4YTCY5PCIT4;Initial Catalog=2019;Integrated Security=True";
            SqlConnection conn = new SqlConnection(scsb.ToString());
            if (conn.State == System.Data.ConnectionState.Closed)
                conn.Open();
            XmlDocument doc1 = new XmlDocument();
            doc1.Load("students.xml");
            XmlNodeList xn = doc1.SelectNodes("students/student");
            string id1;
            string name;
            string sex;
            for (int i = 0; i < xn.Count; i++)
            {
                XmlNode id = xn[i].SelectSingleNode("id");
                id1 = xn[i].SelectSingleNode("id").InnerText;
                name = xn[i].SelectSingleNode("name").InnerText;
                sex = xn[i].SelectSingleNode("sex").InnerText;
                SqlCommand comm = new SqlCommand("insert into students(id,name,sex) values('" + id1 + "', '" + name + "', '" + sex + " ')", conn);
                comm.ExecuteNonQuery();
            }
            XmlDocument doc2 = new XmlDocument();
            doc2.Load("courses.xml");
            XmlNodeList xn2 = doc2.SelectNodes("courses/cname");
            string cno1;
            string course;
            for (int i = 0; i < xn2.Count; i++)
            {
                XmlNode cno = xn2[i].SelectSingleNode("cno");
                cno1 = xn2[i].SelectSingleNode("cno").InnerText;
                course = xn2[i].SelectSingleNode("course").InnerText;
                SqlCommand comm = new SqlCommand("insert into courses(cno,course) values('" + cno1 + "', '" + course + "')", conn);
                comm.ExecuteNonQuery();
            }
            XmlDocument doc3 = new XmlDocument();
            doc3.Load("grades.xml");
            XmlNodeList xn3 = doc3.SelectNodes("grades/grade");
            string cno2;
            string id2;
            int score;
            for (int i = 0; i < xn3.Count; i++)
            {
                XmlNode id = xn3[i].SelectSingleNode("id");
                id2 = xn3[i].SelectSingleNode("grades.id").InnerText;
                cno2 = xn3[i].SelectSingleNode("grades.cno").InnerText;
                score = Convert.ToInt32(xn3[i].SelectSingleNode("score").InnerText);
                SqlCommand comm = new SqlCommand("insert into grades(cno,id,grade) values('" + cno2 + "', '" + id2 + "','" + score + "')", conn);
                comm.ExecuteNonQuery();
            }
            conn.Close();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
            scsb.ConnectionString = "Data Source=70EU4YTCY5PCIT4;Initial Catalog=2019;Integrated Security=True";
            SqlConnection conn = new SqlConnection(scsb.ToString());
            if (conn.State == System.Data.ConnectionState.Closed)
                conn.Open();
            string sqlstr = "select name,course,score from students join grades on students.id=grades.id join courses on courses.cno=grades.cno where courses.course='" + textBox1.Text.Trim() + "' order by score desc";
            SqlDataAdapter da = new SqlDataAdapter(sqlstr,conn);
            DataSet ds = new DataSet();
            da.Fill(ds, "students,courses,grades");
            dataGridView1.DataSource = ds.Tables["students,courses,grades"];
            conn.Close();
        }
    }
}