>All are fine until I issue
>
> daPaper.Fill(dsPaper, "paperoll");
>
>
>If I using the selectCmd as follow then the daPaper.Fill will work fine.
>
> String selectCmd = "select * from paperoll where supNo = 'PM'";
>
>
>So I suspect I parameter statement got problem :
>
> String selectCmd = "select * from paperoll where supNo = ?pSupNo";
> OleDbDataAdapter daPaper = new OleDbDataAdapter(selectCmd, oleDbConnection1);
>
> daPaper.SelectCommand.Parameters.Add(new OleDbParameter("pSupNo",OleDbType.Char,5));
>
> daPaper.SelectCommand.Parameters["pSupNo"].Value = "PM";
>
> DataSet dsPaper = new DataSet();
> daPaper.Fill(dsPaper, "paperoll");
>
>
>Could u pls show me a example how to oledbparameter with VFP table?
>
>TIA.
I'm not a .NET expert but I think the culprit is in supplying a name in parameter. Would you try this:
String selectCmd = "select * from paperoll where supNo = ?";
Cetin