dataGridView删除行后应该如何更新到数据库

来源：百度知道 编辑：UC知道 时间：2024/06/06 01:44:55
try
{
if (this.dataGridView1.SelectedRows.Count > 0)
{
DataRowView drv = dataGridView1.SelectedRows[0].DataBoundItem as DataRowView;
drv.Delete();
MessageBox.Show("删除数据集记录操作成功！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
这样已经把dataGridView1里面选中的行删除了，请问应该更新到数据库，让数据库也删除？？谢谢~是access数据库的~~给点原码~谢谢

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 WindowsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

int r = 0;
string c="";
DataSet ds = new DataSet();

private void button1_Click(object sender, EventArgs e)
{

SqlConnection con = new SqlConnection("Data Source=(local);DataBase=实验;Integrated Security=SSPI");
SqlDataAdapter ada = new SqlDataAdapter("Select * From 学生信息表", con);
ada.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];

}

private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
{
r = e.RowIndex; /*获得具有焦点的行*/
c = data