I tried it too, but still cannot work for me,




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 = mySelect.Value;

daPaper.Fill(dsPaper, "paperoll");


----------------

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 = mySelect.Value;

daPaper.Fill(dsPaper, "paperoll");