C#第四次作业

1. 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;  
     
   namespace theFourthHomework  
   {  
       public partial class Form1 : Form  
       {  
           public Form1()  
           {  
               InitializeComponent();  
           }  
           DataTable dt = new DataTable();  
           private void Form1_Load(object sender, EventArgs e)  
           {  
               // 连接数据库  
               String con = @"Data Source=LONG-PC\LONG;initial Catalog=excel;User id=sa;password=123456;";  
               SqlConnection conn = new SqlConnection(con);  
     
               // 定义数据集  
               DataSet ds = new DataSet();  
               conn.Open();  
               String select = "select * from em03_demo";  
     
               SqlDataAdapter adapter = new SqlDataAdapter(select, con);  
               adapter.Fill(ds);  
               conn.Close();  
     
               // 提取数据表单  
               dt = ds.Tables[0];  
               this.dataGridView1.DataSource = dt;  
     
               // 调整最后一列的宽度  
               dataGridView1.AutoResizeColumn(3, DataGridViewAutoSizeColumnMode.AllCells);  
     
           }  
     
           //添加一行数据  
           private void button1_Click(object sender, EventArgs e)  
           {  
               //添加空行  
               DataRow dr = dt.NewRow();         
               dt.Rows.Add(dr);  
     
               this.dataGridView1.Rows[this.dataGridView1.Rows.Count - 2].Cells[0].Value = this.textBox1.Text;  
               this.dataGridView1.Rows[this.dataGridView1.Rows.Count - 2].Cells[1].Value = this.textBox2.Text;  
               this.dataGridView1.Rows[this.dataGridView1.Rows.Count - 2].Cells[2].Value = this.textBox3.Text;  
               this.dataGridView1.Rows[this.dataGridView1.Rows.Count - 2].Cells[3].Value = this.textBox4.Text;             
           }  
     
           //删除选中行  
           private void button2_Click(object sender, EventArgs e)  
           {  
               int RowNumber;  
               RowNumber = dataGridView1.CurrentCell.RowIndex;  
               dataGridView1.Rows.RemoveAt(RowNumber);  
           }  
     
           //修改后的dataGridView1存入数据库  
           private void button4_Click(object sender, EventArgs e)  
           {  
               try  
               {  
                   //建立数据库连接  
                   String con = @"server=LONG-PC\LONG;database=dataGridView;user id=sa;password=123456";  
                   SqlConnection conn = new SqlConnection(con);  
     
                   //定义sql语句  
                   StringBuilder strsql = new StringBuilder();  
                   conn.Open();  
                   for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)  
                   {  
                       strsql.Append("insert into em03_demo(班级,学号,姓名,作业网址)");  
                       strsql.Append("values(");  
                       strsql.Append("'" + dataGridView1.Rows[i].Cells[0].Value + "',");  
                       strsql.Append("'" + dataGridView1.Rows[i].Cells[1].Value + "',");  
                       strsql.Append("'" + dataGridView1.Rows[i].Cells[2].Value + "',");  
                       strsql.Append("'" + dataGridView1.Rows[i].Cells[3].Value + "')");  
                       using (SqlCommand cmd = new SqlCommand(strsql.ToString(), conn)) //定义连接命令  
                       {  
                           cmd.ExecuteNonQuery();//执行sql语句        
                       }  
                       strsql.Clear();  
                   }  
                   conn.Close(); //关闭数据库  
                   conn.Dispose(); //释放内存空  
                   MessageBox.Show("已存入数据库");  
               }  
               catch (Exception ex)  
               {  
                   MessageBox.Show("学号冲突"+ex.Message);  
               };  
           }  
       }  
   }