在运行中的 DataGridView中添加一个删除行然后执行删除

CC码 2011-11-07 10:16:49

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace 删除作业
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
DataGridViewCheckBoxColumn dgcvbc = new DataGridViewCheckBoxColumn();
SqlConnection conn = new SqlConnection("server=.;database=test;uid=sa;pwd=sa");
SqlCommand cmd = new SqlCommand("select * from sc", conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);

DataGridViewColumn aa = new DataGridViewColumn();
DataGridViewButtonColumn aaa = new DataGridViewButtonColumn();
aaa.Text = "删除";
aaa.UseColumnTextForButtonValue = true;
dataGridView1.DataSource = dt;
dataGridView1.Columns.Add(aaa);
}

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "删除")
{

SqlConnection conn = new SqlConnection("server=.;database=test;uid=sa;pwd=sa");
SqlCommand cmd = new SqlCommand("select * from sc ,student where sc.intsid=student.intsid", conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dtsc = new DataTable();
sda.Fill(dtsc);
DataGridViewSelectedRowCollection dgv = dataGridView1.SelectedRows;
for (int i = 0; i < dgv.Count; i++)
{
string strDe2 = "delete sc where intsid='" + dtsc.Rows[dgv[i].Index]["intsid"] + "'";
string strDe1 = "delete student where intsid='" + dtsc.Rows[dgv[i].Index]["intsid"] + "'";
SqlHepler sh1 = new SqlHepler();
sh1.DedTable(strDe1);
sh1.DedTable(strDe2);
}
SqlHepler sh2 = new SqlHepler();
sh2.GetTable("select * from sc join student on sc.intsid=student.intsid");
dtsc = new DataTable();
dataGridView1.DataSource = dtsc;
}
}
}
}

在数据库中的Test中，有sc和student两个表；
在运行中的 DataGridView中添加一个删除行然后点击删除但是不能执行求解释.......

...全文