I am trying to create a class to perform CRUD operations in a SQL Server Database Table.
I want to be able to Create, Update, or Delete a single row of data in a Table. I have no problem retrieving a single row of data, or multiple rows of data from a table, using the SQL Data Reader. I have spent several hours searching Microsoft help files for examples of how to do this. The MS Help examples all refer to Adding or updating multiple rows at a time, using a Data Adapter. Creating the SQL Query is no problem. Using it with a Data Adapter, or a Data Set, is.
An example of how to retrieve a row of data, modify one or more of the columns, and update that row is what I really need. If you can help, I would appreciate it.
I'm using VisualStudio 2022, and SQJ Server version 15.0.2080
I don't understand how to do that with a Data Adapter, or a Data Set.
What I have tried:
Using various examples from the MS help files, including using a Data adapter to execute a Stored Procedure. Unable to make any of them work. :(