Table data into Array

[Dragster93]

I wish to populate an array with the data from a table. How do I do this?
More specifically, I wish to put the data from a specific column, into the array, and later on add all the values in each cell of the array.

I tried searching on google but I guess I'm using the wrong words to search.

[DataMiser]

datareader would be one method.

[fcronin]

DataTable will provide you a Row collection, and each row will contain the fields selected in your query. So you would access a value using:

string value = dtResults.Rows[0]["FIELDNAME"].ToString();

            DataTable dtResults = new DataTable();

            OleDbConnection dbConnection = new OleDbConnection("your connection string");

            try
            {
                dbConnection.Open();

                if (dbConnection.State == ConnectionState.Open)
                {
                    OleDbCommand dbCommand = dbConnection.CreateCommand();
                    dbCommand.CommandType = CommandType.Text;
                    dbCommand.CommandText = "your query (select * from...)";

                    OleDbDataReader dbReader = dbCommand.ExecuteReader();

                    if (dbReader.HasRows)
                        dtResults.Load(dbReader);

                    dbReader.Close();
                    dbConnection.Close();
                }
            }
            catch (Exception ex)
            {
                throw new Exception("Unable to execute query as requested.", ex);
            }

[robertalis]

Hello

This can also help you, try this

Dim rst As DAO.Recordset
Dim lngNum As Long

Set rst = CurrentDb.Open("TableNameHere")

For 1 to UBound(YourArray)
With rst
.AddNew
!FieldName = YourArray(lngNum)
.Update
End With
lngNum = lngNum + 1
Next


There may be error, not tested, just an overview.

[HanneSThEGreaT]

Thanks for the effort. But, that code is for VB6. This is the C# Forum. Also, that code uses DAO. In .NET ADO is most common...