>Hi
>I'm starting to use C# a fair bit now in Dot net, and am wondering if
> there is any resource out there which has a 'Replacement' table for VFP v's C# commands, particualarly data commands
>(I've got Dot Net for VFP Developers book and also had a look at the VFP toolkit for dot net. These do a good job but dont concentrate on Data type commands.
>If theere was something like the following:
>
>VFP C#
>--- ---
>Seek = ???
>Append Blank = ???
>Replace = ???
>Delete = ???
>
>I realise that the Dot net world is different (using Datasets, datareaders etc) but maybe there some useful info out there somewhere.
>
>regards,
>Gerard


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 :).