How to read data from database and store to an array C#

Question

I need to push the result into an array to be able to display in a chart . I am keep getting System.Data.DataRow instead of the value. I need to know, the proper way to store the result(currently I store it in DataTable), and to push it into an array.I am newbie in c# ..

public void getOutstanding()
{

    SelectQueryBuilder sqbSelect;
    DataSet dsOutstanding;

    sqbSelect = new SelectQueryBuilder();
    sqbSelect.SelectColumns(new string[] { "name"});
    sqbSelect.SelectFromTable("user");
    sqbSelect.AddWhere("category", Comparison.Equals, "18");       

    dsOutstanding = Conn.DataAdapter(CommandType.Text, sqbSelect.BuildQuery());
    sqbSelect = null;

    DataTable areaChart = dsOutstanding.Tables[0];

    for( int a = 0; a < areaChart.Rows.Count; a++) {

       // want to push the value to an array ;       

    }

}

Thank you..

What kind of chart are you using? Usually you can just bind a datatable to a chart like that: chart.DataSource = table; chart.DataBind(); — Mono
– Mono, Commented May 23, 2018 at 7:43
I am using Chart.js, and it need the data to be in array form.. — user3431310
– user3431310, Commented May 23, 2018 at 7:45

Pipat Posawad · Accepted Answer · 2018-05-23 07:48:41Z

1

You can read by using this syntax.

string[] array = new string[areaChart.Rows.Count];
for( int a = 0; a < areaChart.Rows.Count; a++) {
   array[a] = areaChart.Rows[a]["name"].ToString();          
}

answered May 23, 2018 at 7:48

Pipat Posawad

1251 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hesam Faridmehr · Accepted Answer · 2018-05-23 07:49:44Z

1

You can access column data by indexing DataRow with column name

 var names = new string[areaChart.Rows.Count];

 for (var index = 0; index < areaChart.Rows.Count; index++)        
     names[index] = areaChart.Rows[index]["name"].ToString();

answered May 23, 2018 at 7:49

Hesam Faridmehr

1,20610 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to read data from database and store to an array C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related