vb.net getting data from datatable using array

Question

am making a chart, using highcharts, code behind is vb.net...

i have a datatable that is something like this:

Date - speed - data
2011    10k     6
2011    18k     7
2012    20k     10
2012    10k      2
2013    14k      4
2013    20k      6

before when i wanted to get the datatble information for speed, i would use the following code:

 Dim a As DataSet = Cons
    Dim abc As DataTable
    abc = a.Tables(0)

 Dim array As New ArrayList

 For Each row In abc.Rows
        array.Add(row("Speed"))

    Next row

 Dim serializer As New JavaScriptSerializer()
  Dim arrayJson As String = serializer.Serialize(array)

so the code above will show me the data for speed.

however what if i want the data for 2011? or 2013. how would i get this, i have some code that has been done, but as i am using highchart i need to convert this in to array.

how would i change this:

For Each row In abc.Rows
        array.Add(row("Speed"))

    Next row

so that i can get the dates, any ideas anyone.

ok, but what if the year is the same, but day is diffrent,

so

01/10/2011 00:00:00
04/07/2011 00:00:00
21/11/2012 00:00:00
11/11/2013 00:00:00

so how do i call the date of 2011?

Comfortably Numb · Accepted Answer · 2013-06-27 15:59:10Z

2

Since 'abc' is a DataTable, you can use DataTable.Select method.

For example to get the data for year 2011:

For Each row In abc.Select("Date >= #1/1/2011# And Date <= #12/31/2011#")
  array.Add(row("Speed"))
Next row

edited Jun 27, 2013 at 15:59

answered Jun 27, 2013 at 15:45

Comfortably Numb

39.9k17 gold badges82 silver badges147 bronze badges

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

6 Comments

m ali Over a year ago

ok, but what if the year is the same, but day is diffrent, so 01/10/2011 00:00:00 04/07/2011 00:00:00 21/11/2012 00:00:00 11/11/2013 00:00:00 so how do i call the date of 2011?

Comfortably Numb Over a year ago

You should've mentioned that in your post. Please post correct date values. Also what DB you're using? SQL Server?

Comfortably Numb Over a year ago

Assuming that it's a normal date field I've updated my answer.

Comfortably Numb Over a year ago

So does the updated answer "Date >= #1/1/2011# And Date <= #12/31/2011#" work for u?

m ali Over a year ago

no, it wont because i have to many dates, i have some code that already defined this, e.g Dim Year1 As System.Data.EnumerableRowCollection(Of DataRow) year 1 shows the specific data, but i cant call it Dim a As DataSet = Year1 Year1 shows error

|

Collectives™ on Stack Overflow

vb.net getting data from datatable using array

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related