Hi Borislav. Thanks for replying.
When I insert the code I get a compile error:
...cannot implcitly convert type 'string' to stsrem.Data.Oledb.OledbParameter for the dt.Tostring() line

Also, what do I put in my Select String ? Select * from MyTable where MyDateField = @DateTime ??

Tia
Gerard


>>Hi.
>>Uiing C# to read in a VFP Table
>>Trying to get a Select command form VFP with a date Field and using a parameter
>>My Select Command that I want is like: Select * from MyTable where DateField >= MydateControl.Date
>>
>>I am using Oledb
>>MydateControl is a c# Date Control and hlds current date
>>I want to use a Parameter
>>
>>I end up getting a few different messages like Syntax error etc
>>Anybody know the correct syntax for both the Select and adding the Parameter
>>
>>Tia
>>Gerard
>
>

>DateTime dt = DateTime.Now;
>OleDbCommand test = new OleDbCommand();
>test.Parameters.Add("@DateTime", OleDbType.DBDate);
>test.Parameters["DateTime"] = dt.ToString("yyyyMMdd");
>

>?