数据库应用，做项目

SQL Server中有五种约束类型，分别是 PRIMARY KEY约束、FOREIGN KEY约束、UNIQUE约束、DEFAULT约束、和CHECK约束。

 private void button1_Click(object sender, EventArgs e)
        {
            #region 获取用户输入
            string name = this.texname.Text;
            string sex = "";
            if (radioboy.Checked)
            {
                sex = radioboy.Text;
            }
            if (radiogirl.Checked)
            {
                sex = radiogirl.Text ;
            }
            string mobile = this.texMobile.Text;
            string address = this.texadd.Text;
            string departmen = this.comDeper.Text;
            string prize = this.comPrize.Text;
            string grade = this.texGrade.Text;
            string id = this.texId.Text;
            #endregion
            #region 向数据库插入数据
            string sqlserstr = "Data Source=IDEA-PC;Initial Catalog=BookDB;User ID=sa;Password=abcdef";
            SqlConnection conn = new SqlConnection(sqlserstr);
            conn.Open();
            //SqlCommand的CommandText存储的是向数据库发送的sql命令
            SqlCommand cmd = new SqlCommand();
            //将命令对象与连接对象进行关联，命令对象才知道向哪台服务器，哪个数据库发送sql命令
            cmd.Connection = conn;
            cmd.CommandText = "insert into Student3(Name,Sex,Mobile,Address,Departmen,Prize,Grade,Id) values(@name,@sex,@mobile,@address,@departmen,@prize,@grade,@id)";
            #endregion
            #region 参数替换
            cmd.Parameters.AddWithValue("@name", name);
            cmd.Parameters.AddWithValue("@sex", sex);
            cmd.Parameters.AddWithValue("@mobile", mobile);
            cmd.Parameters.AddWithValue("@address", address);
            cmd.Parameters.AddWithValue("@departmen", departmen);
            cmd.Parameters.AddWithValue("@prize", prize);
            cmd.Parameters.AddWithValue("@grade", grade);       
            cmd.Parameters.AddWithValue("@id", id);
            #endregion

            //ExecuteNonQuery方法用来向数据库发送sql命令
            cmd.ExecuteNonQuery();
            MessageBox.Show("注册成功");
        }