using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
SqlDataAdapter a;
DataSet set = new DataSet();
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string sql = "select * from stu";
a = new SqlDataAdapter(sql, DBhepler.con);
a.Fill(set,"stu");
dataGridView1.DataSource = set.Tables["stu"];
}
private void button1_Click(object sender, EventArgs e)
{
SqlCommandBuilder comm = new SqlCommandBuilder(a);
a.Update(set, "stu");
string b = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
string sql=string.Format("delete from stu where id={0}",Convert.ToInt32(b));
DBhepler.con.Open();
SqlCommand com = new SqlCommand(sql,DBhepler.con);
int num = com.ExecuteNonQuery();
if (num > 0)
{
MessageBox.Show("删除成功!");
}
}
}
}