Скачать или смотреть How to Delete DataGridView Selected Rows from SQL DataTable in C#

Learn how to effortlessly delete selected rows from a `DataGridView` bound to an SQL `DataTable` in C# . This guide covers step-by-step solutions to address common challenges.
---
This video is based on the question https://stackoverflow.com/q/73870628/ asked by the user 'Christoforos' ( https://stackoverflow.com/u/16224984/ ) and on the answer https://stackoverflow.com/a/73871317/ provided by the user 'John' ( https://stackoverflow.com/u/18877258/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: C# How to delete datagridview SelectedRows from SQL datatable

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Delete DataGridView Selected Rows from SQL DataTable in C#

Managing data in a user-friendly way is crucial in applications that deal with databases. One common task developers face is allowing users to delete selected records directly from a DataGridView connected to a SQL DataTable. This post will guide you through the process, addressing a common pitfall and providing two effective solutions.

The Problem: Deleting Selected Rows

Imagine you have a DataGridView bound to a SQL DataTable. Your users are selecting rows they want to delete, and you need to implement a button that effectively removes these selected rows from the underlying data table. However, a common issue arises when trying to keep track of the selected rows.

You might try to use an array to store the row indices but find that it goes out of scope after the loop, causing an error when you attempt to access it later. This is a typical scenario where understanding scope and data handling in C# becomes essential.

Let’s break this down and provide a solution.

The Solution: Methods to Delete Selected Rows

Method 1: Using DataRowView

If your DataGridView is bound to a DataTable, you can take advantage of the DataBoundItem property of each selected row. Here’s how:

Retrieve Selected Rows: Use LINQ to cast the selected rows to DataRowView.

Delete Rows: Call the Delete method on each retrieved row.

Commit Changes: Use a data adapter to update the database.

Here’s how to implement it in code:

[[See Video to Reveal this Text or Code Snippet]]

Method 2: Using BindingSource

Another approach is using a BindingSource. This method also allows you to remove rows but does so by calling RemoveAt on the BindingSource. Here’s a step-by-step breakdown:

Get Row Indexes: Create an array of the selected row indices.

Remove Selected Rows: Use a reverse loop to remove rows from the BindingSource.

Here’s the implementation:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

Deleting selected rows from a DataGridView bound to an SQL DataTable can initially be a challenge, especially when it comes to managing scopes of variables. However, with the solutions provided above, you can effectively manage the deletion process.

Whether you choose to retrieve DataRowView or operate through a BindingSource, ensure that your DataAdapter is ready to commit the changes to your database. Implement this functionality to improve the user experience in your applications and provide seamless data management capabilities!