How can I using parameters to select data subset of data from VFP table.

I try using following code, but can't work for me.

Thanks.


-------------------
String selectCmd = "select * from paperoll where supNo = @supNo";

OleDbDataAdapter daPaper = new OleDbDataAdapter(selectCmd, oleDbConnection1);

daPaper.SelectCommand.Parameters.Add(new OleDbParameter("@supNo",OleDbType.Char,5));

daPaper.SelectCommand.Parameters["@supNo"].Value = mySelect.Value;

DataSet dsPaper = new DataSet();
daPaper.Fill(dsPaper, "paperoll");

DataGrid1.DataSource= dsPaper.Tables["paperoll"].DefaultView;
DataGrid1.DataBind();