Форум программистов [Powered by Invision Power Board]

Код

protected void Button1_Click(object sender, EventArgs e)
    {
        string[] arrNames;
        string[] arrPass;
        
        int i = 0;
        string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/1.mdb";
        string queryString = "SELECT Id, fName, fPass FROM users";
        using (OleDbConnection connection = new OleDbConnection(connectionString))
        {
            OleDbCommand command = new OleDbCommand(queryString, connection);
            connection.Open();
            using (OleDbDataReader reader = command.ExecuteReader())
            {
                arrNames = new string[reader.FieldCount];
                arrPass = new string[reader.FieldCount];
                while (reader.Read())
                {
                    int customerId = reader.GetInt32(0);
                    string Name = reader.GetString(1);
                    string pass = reader.GetString(2);
                    i = i + 1;
                    arrNames[i - 1] = Name;
                    arrPass[i - 1] =pass;

                   
                }
                reader.Close();
                //
            }

          
        }
        }