problem in passing parameter to foxpro database6,using ado.net and vb.net

[vijju]

hi,
iam working on an application using vb.net,ado.net and visual foxpro database..


iam getting a problem while inserting data into foxpro database.

i need to pass a boolean value to one of the fields.

if iam passing false or true its giving data type mismatch.

the foxpro database is accessing .F. for false and .T. for true

for this iam trying to pass false as string in foxpro type

like ".F.",but its giving data type mismatch..

DBObjects.AddParameter(oComm, "UpdateFlg", DbType.String, ParameterDirection.Input, ".F.")


iam using odbc.net provider,since iam working with vfp6.

so please tell me how could i rectify this problem.is there a way to convert VB.NET boolean type to Foxpro boolean type.

does odbc.net supports any conversion,if any how,

otherwise how to solve this problem.

please help me....
regards
varma