I think you need to use a "?" in your Select Command instead of an "@".
String selectCmd = "select * from paperoll where supNo = ?supNo";
Everything else should be ok the way you have it.
~~Bonnie
>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();