Opps David,

forget that you can use VFP toolkit for .NET.
Forget that you can use VFP at all. Assume that VFP is not invented yet

Give me a clean .Net working code please.

Jordan

>
>Autonumbering? Like record counting?
>
>string lcConnectionString;
>string lcSQL;
>OleDbConnection oConn;
>
>//Get the connection string and sql statement
>lcConnectionString = "Provider=vfpoledb.1;Data Source='C:\\Program Files\\Microsoft Visual FoxPro 7\\Samples\\Data\\testdata.dbc';password='';user id=''";
>lcSQL = "Select * from customer";
>
>//Connect to the Database, execute the query and disconnect
>//SqlConnect(), SqlExecute(), SqlDisconnect()
>oConn = SqlConnect(lcConnectionString);
>goView = SqlExecute(oConn, lcSQL, "CustomerList");
>SqlDisConnect(oConn);
>
>//Select the default cursor and browse it
>VFPToolkit.vfpData.Select(goView);
>Browse();
>lnreccount = VFPToolkit.vfpData.reccount(goView)
>
>Couldnt you just use a reccount to autonumber?
>This is an example from the VFP toolkit for .NET, might I add it works great for connecting with .DBF files via oledb, and it does not require VFP dlls. Your .NET project just needs a reference it the toolkit.
>
>I saw this link in another forum, it might be useful for you...
>
>http://www.vistasoftware.com/apollo_net.asp