c#第四次作业 c#操作MySQL数据库

来源：互联网发布：java并发编程应用在哪编辑：程序博客网时间：2024/05/29 10:09

<span style="font-size:32px;">关键代码如下</span>

        //添加一行数据        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=ADMIN/PC;database=shop;user id=sa;password=lihua";                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("已存入数据库");            }

0 0