实验三：增、删、改、查

在上一个实验中利用dataGridView添加数据源，将Student中的数据导入进来，并添加好需要的控件。

1. 增加

SqlConnection con = new SqlConnection("Data Source =.; Initial Catalog = Text;  Persist Security Info = True;User ID = sa; Password = 110023");
        private void buttonInsert_Click(object sender, EventArgs e)//增加
        {
   
            string StuSno = textBox1.Text.Trim();
            string StuSname = textBox2.Text.Trim();
            string StuSsex = textBox3.Text.Trim();
            string StuSage = textBox4.Text.Trim();
            string StuSdept = textBox4.Text.Trim();
            //SqlConnection con = new SqlConnection("Data Source =.; Initial Catalog = Student;  Persist Security Info = True;User ID = sa; Password = 123"); //连接数据库
            try
            {
   
                con.Open();     //打开数据库
                string insertStr = "INSERT INTO Student(Sno,Sname,Ssex,Sage,Sdept)" + "VALUES('" + StuSno + "','" + StuSname