Breaking News: Grepper is joining You.com. Read the official announcement!

sql table to array 2d c#

Sore Stork answered on September 29, 2022 Popularity 1/10 Helpfulness 1/10

answer sql table to array 2d c#

related sql table to array 2d c#

sql table to array 2d c#

Comment

  public static IEnumerable<List<object>?> Reader(SqlConnection? sqlConnection, string query)
    {
        if (sqlConnection == null) yield return null;
        //https://social.msdn.microsoft.com/Forums/en-US/b60ca36a-2102-4fb3-bf49-5dcecb9eb2c2/convert-sqldatareader-to-list-of-objects?forum=csharpgeneral
        using (SqlCommand sqlCommand = new SqlCommand(query, sqlConnection))
        {
            using (var reader = sqlCommand.ExecuteReader())
            {
                var indices = Enumerable.Range(0, reader.FieldCount - 1).ToList();
                foreach (IDataRecord record in reader as IEnumerable)
                    yield return indices.Select(i => record[i]).ToList();
            }
        }
    }

Popularity 1/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: 2d c# sql

Link to this answer
Share Copy Link

Contributed on Sep 29 2022

Sore Stork

0 Answers Avg Quality 2/10

Closely Related Answers

sql table to array 2d c#

Comment

public static DataTable ReadSqlToDatatable(SqlConnection sqlConnection, string query)
    {
        DataTable dataTable = new DataTable();
        SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
        SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
        sqlDataAdapter.Fill(dataTable);
        return dataTable;
    }

    public static object[][] ReadSqlToArray(SqlConnection sqlConnection, string query)
    {
        DataTable dataTable = ReadSqlToDatatable(sqlConnection, query);
        object[][] Array2D = dataTable.AsEnumerable().Select(x=>x.ItemArray).ToArray();
        return Array2D;
    }

Popularity 1/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: 2d c# sql

Link to this answer
Share Copy Link

Contributed on Sep 29 2022

Sore Stork

0 Answers Avg Quality 2/10

sql table to array 2d c#

Contents

More Related Answers

sql table to array 2d c#

Closely Related Answers

sql table to array 2d c#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.