使用 MS Access DB 从 DataGridView 中删除选定的行

本文关键字：删除 DataGridView MS Access DB 使用 | 更新日期: 2023-09-27 18:35:15

再次出现问题。我可以从DVG中删除该行，但是当我关闭程序并重新运行它时，该行会重新出现。我在网上看了几个例子，真的很难让他工作。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data.OleDb;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
    public partial class FormAccounts : Form
    {
        public FormAccounts()
        {
            InitializeComponent();
            this.accountsTableAdapter.Fill(this.accountsDataSet.Accounts);
        }    
        private void BTNADD_Click(object sender, EventArgs e)
        {
            MessageBox.Show("Make sure you have checked the Date before Adding");
            OleDbConnection conn = new OleDbConnection();
            conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:'Users'kenny'Documents'Visual Studio 2010'Projects'Copy Cegees'Cegees'Cegees'Accounts.accdb";
            String TheDate = DTPAccounts.Value.ToShortDateString();
            String Moneyin = TextMoneyin.Text;
            String Retailin = TextRetailin.Text;
            String Rent = TextRent.Text;
            String Stock = TextStock.Text;
            String Misc = TextMisc.Text;
            String Water = TextWater.Text;
            String Fuel = TextFuel.Text;
            String Phone = TextPhone.Text;
            OleDbCommand cmd = new OleDbCommand("Insert Into Accounts ([TheDate], [Moneyin], [Retailin], [Rent], [Stock], [Misc], [Water], [Fuel], [Phone]) Values (@TheDate, @Moneyin, @Retailin, @Rent, @Stock, @Misc, @Water, @Fuel, @Phone)");
            cmd.Connection = conn;
            conn.Open();
            if (conn.State == ConnectionState.Open)
            {
                cmd.Parameters.Add("@TheDate", OleDbType.VarChar).Value = TheDate;
                cmd.Parameters.Add("@Moneyin", OleDbType.VarChar).Value = Moneyin;
                cmd.Parameters.Add("@Retailin", OleDbType.VarChar).Value = Retailin;
                cmd.Parameters.Add("@Rent", OleDbType.VarChar).Value = Rent;
                cmd.Parameters.Add("@Stock", OleDbType.VarChar).Value = Stock;
                cmd.Parameters.Add("@Misc", OleDbType.VarChar).Value = Misc;
                cmd.Parameters.Add("@Water", OleDbType.VarChar).Value = Water;
                cmd.Parameters.Add("@Fuel", OleDbType.VarChar).Value = Fuel;
                cmd.Parameters.Add("@Phone", OleDbType.VarChar).Value = Phone;
                try
                {
                    cmd.ExecuteNonQuery();
                    MessageBox.Show("Customer Added");
                    conn.Close();
                }
                catch (OleDbException ex)
                {
                    MessageBox.Show(ex.Source);
                    MessageBox.Show(ex.ToString());
                    conn.Close();
                }
             }
          }
        private void BTNView_Click(object sender, EventArgs e)
        {
            DVGAccounts.Visible = !DVGAccounts.Visible;
        }

        private void BTNDelete_Click(object sender, EventArgs e)
        {
            {
                DialogResult dr = MessageBox.Show("Are you sure you want to delete", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (dr == DialogResult.Yes)
                {
                    if (this.DVGAccounts.SelectedRows.Count > 0)
                    {
                       DVGAccounts.Rows.RemoveAt(DVGAccounts.CurrentRow.Index);
                       this.accountsTableAdapter.Update(this.accountsDataSet.Accounts);
                        accountsDataSet.AcceptChanges();
                        ;
                    }
                }

            }
        }
    }
}

使用 MS Access DB 从 DataGridView 中删除选定的行

我设法使用按钮上的这段代码让它工作。 

private void BTNDelete_Click(object sender, EventArgs e)
{
    DialogResult dr = MessageBox.Show("Are you sure you want to delete", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
    if (dr == DialogResult.Yes)
    {
        if (this.DVGAccounts.SelectedRows.Count >0 && this.DVGAccounts.SelectedRows[0].Index != this.DVGAccounts.Rows.Count -1)
        {
            this.DVGAccounts.Rows.RemoveAt(this.DVGAccounts.SelectedRows[0].Index);
        }
    }
}

您仅从 DataGridView 中删除该行，这是一个内存中的构造。如果希望它从数据库中删除行，则必须具有配置为通过打开的连接连接到表的 DataGridView，或者通过发出 delete 语句来响应删除记录，其方式与插入操作的方式相同。但是，我建议尝试使事情更加自动化，因此连接的DGV可能会有所帮助。

相关文章：