Which statement is it crashing on and what's the error that you're getting? All you've said is that it's not working, but you haven't said *what's* not working. Have you tried debugging it and stepping through the code?

~~Bonnie


>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");