Странное исключение при просмотре поля Access

[adwaer]

Ответьте пожалуйста почему выдаётся на

try
{     log = Convert.ToString(myOleDbDataReader["password"]);
}

Выдаётся исключение IndexOutOfRangeException, в описании ошибки написано "password"

В таблице db.mdb 3 поля: [Num]:счетчик[user]:текст[password]:текст

Буду очень благодарен если поможете.

string connectionString =
                                    "provider=Microsoft.Jet.OLEDB.4.0;" +
                                    "data source=C:\\mobile_system\\db.mdb";
                                OleDbConnection myOleDbConnection = new OleDbConnection(connectionString);
                                OleDbCommand myOleDbCommand = myOleDbConnection.CreateCommand();


                                string log = "";

                                        myOleDbCommand.CommandText =

                                          "SELECT user " +

                                            "FROM auth " +

                                              "WHERE user = ?" ;

                                        OleDbParameter dataDoc = myOleDbCommand.Parameters.Add("@user", OleDbType.VarChar);
                                        dataDoc.Value = login.Text;

                                        myOleDbConnection.Open();                                       
                                    
                                     OleDbDataReader myOleDbDataReader = myOleDbCommand.ExecuteReader();

                                     myOleDbDataReader.Read();

                                     try
                                     {
                                         log = Convert.ToString(myOleDbDataReader["user"]);
                                     }
                                     catch (InvalidOperationException)
                                     {
                                         MessageBox.Show("Пользователь не зарегистрирован");
                                     }
                                     myOleDbConnection.Close();


                                     string connect =
                                     "provider=Microsoft.Jet.OLEDB.4.0;" +
                                     "data source=C:\\mobile_system\\db.mdb";
                                     OleDbConnection Connection = new OleDbConnection(connect);
                                     OleDbCommand Command = Connection.CreateCommand();
                                    
                                    
                                     Command.CommandText =

                                           "SELECT user " +

                                             "FROM auth " +

                                               "WHERE user = ?";

                                     OleDbParameter pas = Command.Parameters.Add("@password", OleDbType.VarChar);
                                     pas.Value = pass.Text;

                                     Connection.Open();
                                     OleDbDataReader Reader = Command.ExecuteReader();
                                     Reader.Read();

                                     try
                                     {
                                         object b = Reader["password"];
                                     }
                                     catch (InvalidOperationException)
                                     {
                                         MessageBox.Show("Пользователь не зарегистрирован");
                                     }



                                     this.Text = "+7" + login.Text;
                                     this.Hide();
                                     new client(this).Show();

[akasex]

did you tried : "WHERE user = @password" instead of "WHERE user = ?" ???

[adwaer]

Thank you!