<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("已存入数据库");
}