Hi Bill. Thanks for that.
How do you initialise the date parameter to a string as VFP will expect a VFP date
I get an error with --> test.Parameters["DateTime"] = dt.ToString("yyyyMMdd");
Regards,
Gerard
>>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");
>>>
>>>?
>
> VFP Syntax uses ? instead of @parm
>Select * from MyTable where MyDateField = ?