Did David's or Cetin's replies help? I don't use VFP tables, so I'm not 100% sure of the syntax for adding the OleDbParameters for VFP.

~~Bonnie


>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.