SqlDataAdapter sda = new SqlDataAdapter("select*from xsda", "Data Source=.;Initial Catalog=XS;Integrated Security=True");
     DataTable dt = new DataTable();
     sda.Fill(dt);
     dataGridView1.DataSource = dt;
        }

        dbcon db = new dbcon();
        //第一种方法
        private void button2_Click(object sender, EventArgs e)
        {
            SqlConnection sqlcon = db.Mycon();
          
            DataSet daxsda = new DataSet();
           SqlCommand   sqlcom = new SqlCommand();
           try
           {
               sqlcon.Open();
               sqlcom.Connection = sqlcon;
               sqlcom.CommandText = "insert into xsda values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + null + "')";



               int i = sqlcom.ExecuteNonQuery();
               SqlCommand sqlcm = new SqlCommand();
               sqlcm.CommandText = "select*from xsda ";
               sqlcm.Connection = sqlcon;
               SqlDataAdapter sldp = new SqlDataAdapter();
               sldp.SelectCommand = sqlcm;
               DataSet ds1 = new DataSet();
               sldp.Fill(ds1, "xsda");
               dataGridView1.DataSource = ds1.Tables[0];
           }
           catch (Exception ex)
           {

               MessageBox.Show(ex.Message);
           }
           sqlcom.Dispose();
           sqlcon.Close();

            

        }
        //统计人数

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection sqlcon1 = db.Mycon();
          
            SqlCommand sqlcom1 = new SqlCommand();
            try
            {
                sqlcon1.Open();
                sqlcom1.Connection = sqlcon1;
                sqlcom1.CommandText = "select count(学号) from xsda";
                int i = Convert.ToInt32(sqlcom1.ExecuteScalar());
                textBox8.Text = i.ToString();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
          
                sqlcom1.Dispose();
      
            
            sqlcon1.Close();
            
            




        }
        //第二种方法
        private void button3_Click(object sender, EventArgs e)
        {
            SqlConnection sqlcon = db.Mycon();
            sqlcon.Open();
        
            SqlCommand sqlcom = new SqlCommand();
            sqlcom.Connection = sqlcon;
            sqlcom.CommandText = "XSADD";
            sqlcom.CommandType = CommandType.StoredProcedure;
            try
            {

                //SqlDataReader sldr = sqlcom.ExecuteReader();
                sqlcom.Parameters.Add("@id", SqlDbType.Char,6).Value = textBox1.Text;
                sqlcom.Parameters.Add("@name", SqlDbType.Char,10).Value = textBox2.Text;


                sqlcom.Parameters.Add("@sex", SqlDbType.Bit).Value = textBox3.Text;

                sqlcom.Parameters.Add("@birth", SqlDbType.SmallDateTime).Value = Convert.ToDateTime(textBox4.Text);
                  sqlcom.Parameters.Add("@xim", SqlDbType.Char,20).Value = textBox5.Text;
                  sqlcom.Parameters.Add("@minzu", SqlDbType.Char, 2).Value = textBox6.Text;
                sqlcom.Parameters.Add("@score", SqlDbType.Int).Value =Convert.ToInt32(textBox7.Text);
          
  

                

                int i = sqlcom.ExecuteNonQuery();
                SqlDataAdapter sld = new SqlDataAdapter();
                DataSet ds1 = new DataSet();
                sld.Fill(ds1, "XSDA");

                dataGridView1.DataSource = ds1.Tables[0];
            }
            catch(Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
            
            

          
        }
        DataSet ds;
        DataTable dt;
        //第三种方法
        private void button4_Click(object sender, EventArgs e)
        {
            ds = new DataSet();
            dt = new DataTable();
            try
            {
                dt.Columns.Add("学号", typeof(int));
                dt.Columns.Add("姓名", typeof(string));
                dt.Columns.Add("性别", typeof(Boolean));
                dt.Columns.Add("系名", typeof(string));
                dt.Columns.Add("出生年月", typeof(string));
                dt.Columns.Add("民族", typeof(string));
                dt.Columns.Add("总学分", typeof(int));
              
                DataRow row = dt.NewRow();
                row[0] = textBox1.Text.Trim();
                row[1] = textBox2.Text.Trim();
                row[2] = textBox3.Text.Trim();
                row[3] = textBox4.Text.Trim();
                row[4] = textBox5.Text.Trim();
                row[5] = textBox6.Text.Trim();
                row[6] = textBox7.Text.Trim();
              
                dt.Rows.Add(row);
                ds.Tables.Add(dt);

                dataGridView1.DataSource = ds.Tables[0];
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }



        }
    }
}