Build your own SQL queries to maximize the efficiency of ExecuteNonQuery

摘要

One of the most preferred methods for editing database data is via DataSet and DataAdapter objects. This duo makes it easy for you to implement editable forms (when you bind the Da t aSe t to controls like the DataGrid) and objects like the CommandBui lder allow you to automatically generate the necessary INSERT, UPDATE, and DELETE commands using the DataAdapter Command text. Of course, this isn't the most efficient way to update database data. Binding is costly and the SQL queries created by the CommandBui Ider contain a lot of unnecessary baggage. A better alternative for updating database records is the ExecuteNon-Query( ) function and, in this article, we'll show you an easy way to utilize it while maintaining a couple of the key benefits of the DataSet/DataAdapter duo.