• 0

[VB .NET]Dataset Into An Array


Question

I have a dataset (Comes from an SQL Database) in VB .NET I need to put into an array so I can play around with it (And pass it to a webchart but thats a different story). How do I go about doing this? I cant seem to find a way to get the data from the dataset into an array :cry:

Also whats the difference between a Dataset,Datatable and DataView?

Link to comment
https://www.neowin.net/forum/topic/516744-vb-netdataset-into-an-array/
Share on other sites

9 answers to this question

Recommended Posts

  • 0

Ok, this code is for VB Classic, so it wont take much change

DIM i as integer

Dim arValues(0) as string 'or whatever your data types are.

i = 1

Do while NOT rs.EOF

Redim PRESERVE arValue(i) 'Preserve is important here!

arValues(i) = rs.Fields(0).Value

i = i + 1

rs.MoveNext

Loop

But I sonder why your control cannot be populated by the dataset/resultset/recordset directly?

Peace,

James

  • 0
  jameswjrose said:

Ok, this code is for VB Classic, so it wont take much change

DIM i as integer

Dim arValues(0) as string 'or whatever your data types are.

i = 1

Do while NOT rs.EOF

Redim PRESERVE arValue(i) 'Preserve is important here!

arValues(i) = rs.Fields(0).Value

i = i + 1

rs.MoveNext

Loop

But I sonder why your control cannot be populated by the dataset/resultset/recordset directly?

Peace,

James

You mean the webchart control?

  • 0
  Sawyer12 said:

You mean the webchart control?

yes, Im surprised the Webchart control does not have another entry point other than an array.

It seems a waste of time to take data out of a heavy array (recordset/dataset/etc) into a lightweight array, and then place that data into the webchart control.

But since I dont know the control and it's capabilities... I'm talking out my... well, you get the idea.

Best of luck

  • 0
  Sawyer12 said:

I need to do some playing around with the data before I use it.

Ok. I still use Datasets/Recordsets. I can update, sort, filter and do many more things with these heavy arrays than I can do EASILY with standard arrays.

But hey, that's just me.

  • 0
  Sawyer12 said:

I have a dataset (Comes from an SQL Database) in VB .NET I need to put into an array so I can play around with it (And pass it to a webchart but thats a different story). How do I go about doing this? I cant seem to find a way to get the data from the dataset into an array :cry:

Also whats the difference between a Dataset, Datatable and DataView?

A DataSet is a collection of data, generally DataTables.

A DataTable is just that; an in memory representation of a data table. It has primary keys, relationships, types, rows, columns, etc.

A DataView is a read-only view of a DataTable. You'll probably want to use this if you're iterating thru it to populate an array, or forgo the Dataset altogether and use a DataReader and read into an array. A DataReader is a read-only, forward-only recordset which has far less overhead than a DataSet. In your case, you'd use a SqlDataReader.

Do you need to put only one particular field into an array, or the entire table?

' using a SqlDataReader
Dim reader As SqlDataReader = command.ExecuteReader()
Dim items As new List(Of String) ' or Of whatever type you need

while(reader.Read())
	' get col by name
	' items.Add( reader("username") )
	' or by index
	items.Add( reader(0) ) ' gets the value for the first column
end while

  • 0

Does the Dataset have one value per row, or multiple values per row? If multiple values per row, and you want these in the array, here:

  Quote

For x As Integer = 0 To ds.Tables(0).Rows.Count -1

MyArray(x, 0) = ds.Tables(0).Rows(x)(0)

MyArray(x, 1) = ds.Tables(0).Rows(x)(1)

MyArray(x, 2) = ds.Tables(0).Rows(x)(2)

Next

You could do a simple piece of code like this, number of lines depending on number of values in a Datarow.

  • 0
  LRoling said:

Does the Dataset have one value per row, or multiple values per row? If multiple values per row, and you want these in the array, here:

You could do a simple piece of code like this, number of lines depending on number of values in a Datarow.

Why the -1 on the end?

  • 0

The -1 line would make a little more sence with parathese

For x As Integer = 0 To (ds.Tables(0).Rows.Count -1)

For example let's say your data set has 10 rows

Since you start at ZERO in the loop, and you need to go for 10 trips through the loop (the count value) zero to nine is ten trips. Since arrays are zero based your array would have the values 0, 1, 2... 8, 9

Get it? Good.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • No, you dumba** The whole conversation was about having backups......... And yes, you can have the cloud to access them between your devices, but -always- have backups. It's not that hard to understand is it?
    • Playing Sonic on a touchscreen tablet is as terrible as I imagined.
    • It's weird how some people don't know how to read the article... "If you remember the tests SpaceX was performing around 2012 with Grasshopper, well Honda is at about the same stage with its reusable rocket."
    • Microsoft Project 2021 Professional for Windows now just $9.97 by Steven Parker Today's highlighted deal comes from our Apps & Software section of the Neowin Deals store, where you can save $240 off Microsoft Project 2021 Professional for Windows. Be the boss of any project with Microsoft Project Professional 2021. This powerful yet easy-to-use app lets you stay on track, from small tasks to larger projects. Manage your projects more efficiently with the right timelines, budgets, and resources. You'll get automated scheduling tools as well as built-in reports to help you reduce inefficiencies and make better, informed decisions. Project management has never been this easy with Microsoft Project Pro. Lifetime license for Microsoft Project Professional 2021 One-time purchase installed on 1 Windows PC for use at home or work Instant Delivery & Download – access your software license keys and download links instantly Free customer service – only the best support! Why Microsoft Project Professional 2021? Pre-built templates help you get your project started on the right track Sync with Project Online and Project Server Submit timesheets to capture time spent on project and non-project work Run what-if scenarios to make the most of your task assignments Auto-populate start and end dates based on dependencies Visually represent complex schedules with built-in multiple timelines Supports Long-Term Servicing Channel (LTSC) and is compatible with Office LTSC and Office 2021 Good to know Length of access: lifetime Redemption deadline: redeem your code within 30 days of purchase Access options: desktop Max number of device(s): 1 Version: 2021 Pro Updates included Microsoft Project 2021 Professional for Windows normally costs $249.99, but it can be yours for just $14.97 for a limited time, that's a saving of $235. For terms, specifications, and license info please click the link below. Use MSO5 when checking out for additional $5 off. Coupon Expires June 29 Get Microsoft Project 2021 Professional for Windows for just $9.97, or learn more Although priced in U.S. dollars, this deal is available for digital purchase worldwide. We post these because we earn commission on each sale so as not to rely solely on advertising, which many of our readers block. It all helps toward paying staff reporters, servers and hosting costs. Other ways to support Neowin Whitelist Neowin by not blocking our ads Create a free member account to see fewer ads Make a donation to support our day to day running costs Subscribe to Neowin - for $14 a year, or $28 a year for an ad-free experience Disclosure: Neowin benefits from revenue of each sale made through our branded deals site powered by StackCommerce.
    • Weird how some people don't need to crash 7 rockets before they get it right.
  • Recent Achievements

    • Week One Done
      slackerzz earned a badge
      Week One Done
    • Week One Done
      vivetool earned a badge
      Week One Done
    • Reacting Well
      pnajbar earned a badge
      Reacting Well
    • Week One Done
      TBithoney earned a badge
      Week One Done
    • First Post
      xuxlix earned a badge
      First Post
  • Popular Contributors

    1. 1
      +primortal
      678
    2. 2
      ATLien_0
      286
    3. 3
      Michael Scrip
      224
    4. 4
      +FloatingFatMan
      197
    5. 5
      Steven P.
      137
  • Tell a friend

    Love Neowin? Tell a friend!