Hi,
Below are the equivalent of VFP to C#. For a clearer idea on this, read Mastering C# Database Programming
VFP C#
This are use in conjunction to Datasets, dataadapter, Datatable etc....
>--- ---
Seek = FIND()-disadvantageous in record search,use STPROC/SQLSelect
Append Blank = Rows.Add()
Replace = UPDATE(DataTable)
Delete = RemoveDataRow.Delete()
BTW, its better to use Stored Procedures to Add, update and delete records than using a datasets in your app. Don't rely on datasets...a bad design of using datasets to a database application may lead to user frustration on the application and to the developer.
Just because an app uses stored procedures [which it should] doesn't mean it shouldn't use datasets. Datasets are a great way to create disconnected views of data, for viewing result sets, reporting, etc. What's your specific reasoning here?
Kevin