tags:

views:

549

answers:

2
+2  Q: 

DataGridView, DataTable, SqlDataAdapter and SqlCommandBuilder - disable deletes

I have a WinForm that has a DataGridView table. It is bound to a DataTable in conjunction with a SqlDataAdapter and SqlCommandBuilder. What is the best way (easy and easy to manage) of disabling Deletes but allowing Selects, Updates, Inserts?

Is there a one line property I can set on the grid? That is how I would prefer to do it.

+2  A: 

Probably the easiest thing to do is to look over the properties on your DataGridView and change the AllowUserToDeleteRow to false.

RSolberg  2009-06-02 16:01:58
How do you remove the delete command? The only way I can delete now is selecting the Row and hitting the "delete" keyboard button.
tyndall  2009-06-02 16:03:40
I updated the answer a bit with the specific way of handling this.
RSolberg  2009-06-02 16:33:03
+1 sweet thanks. By the way, is the "delete" key on the keyboard the only method supported of deleting... or did I miss something?
tyndall  2009-06-02 16:43:06
I think in this example it is the only way of doing it. I tend to do more web forms vs. win forms programming and its a little different...
RSolberg  2009-06-02 17:26:50
A: 

how to delete dataset record with datagridview connection sqldataadapter?

ahmad  2010-06-20 02:37:28

related questions

Subsonic Vs NHibernate
How to check For File Lock in C# ?
Is nAnt still supported and suitable for .net 3.5/VS2008?
Limit size of Queue<T> in .NET?
Viewstate invalid when using Safari
Free OCR library
Unhandled Exception Handler in .NET 1.1
Localising date format descriptors
Get a new object instance from a Type in C#
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
.NET Testing Framework Advice
Embedded Database for .net that can run off a network
Automatically update version number
Homegrown consumption of web services
How do you migrate a large app from VB6 to VB .net ?
.NET Migrations Engine
Adding Scripting functionality to .NET applications
SQLite and XSD
Floating Point Number parsing: Is there a Catch All algorithm?
How do I programmatically create a PDF in my .NET application?
How do I sync the SVN revision number with my ASP.NET web site?
XSD DataSets and ignoring foreign keys
Anatomy of a "Memory Leak"
Reliable Timer in a Console Application
How do I calculate relative time?