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.