• 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

    • Weird how some people don't need to crash 7 rockets before they get it right.
    • Or it's a bug that can easily be fixed with an update. My guess is the limitation is there to prevent game makers from doing dumb things like having a racing game constantly rumble while the car is in motion. Sounds like the threshold or detection needs to be tweaked if it is triggering for no reason.
    • Nice I guess. Azure's DaaS feature has supported that for years. It's so odd to me how MS is deploying Azure and 365 DaaS as two totally different services with different features. I would think the 365 cloud desktops would just be a slightly dumbed down frontend that manages the same service.
    • Oh and gaming on a PC cost way more. To get PS5 Pro performance on a PC it will cost you more, especially with the crazy GPU costs today. While you can play Last of US and Horizon, finally, you cant play GT7 unless you have a PS5 (other games as well).
    • IT admins will soon be able to provision cloud apps rather than entire Windows 365 Cloud PCs by Usama Jawad As we discussed earlier, Windows 365 Cloud PC is a neat way to access virtualized operating systems without getting access to physical hardware. It makes it much easier to work in hybrid or remote environments using hardware and software managed on the cloud by your organization. However, Microsoft is making this process even more convenient with a private preview for Windows 365 Cloud Apps. In its announcement, Microsoft has revealed that it is testing a way to deliver individual apps to users securely via Windows 365, instead of having an entire Cloud PC provisioned for them. It is important to note that these apps will still be hosted on the Cloud PC, a user just won't need access to a dedicated Cloud PC. Microsoft believes that this improved way of app delivery will facilitate seasonal and remote workers by getting them access to just the line-of-business (LOB) apps that they require, while also offering centralized and simplified management capabilities. Importantly, Redmond believes that this will facilitate migration from on-prem virtual desktop infrastructure (VDI) to the cloud too. Deploying this new experience is fairly straightforward for any IT admin who has prior experience with setting up Windows 365. They will need to select an "app-only" experience during the configuration process instead of the full desktop mode and then control the licenses and app access. During this private preview period, only apps available in the Start menu of the gallery or custom images are supported, but more types of apps will be supported for streaming as we get closer to general availability (GA). On the end-user side, customers with Cloud Apps provisioned for them will be able to launch them from the Windows App gateway. Any security policy that applies to the associated Cloud PC will also apply to the Cloud App in use. Microsoft has encouraged those interested in joining the private preview to contact their Microsoft account team or fill in this form. There is no word yet regarding general availability.
  • 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
      668
    2. 2
      ATLien_0
      284
    3. 3
      Michael Scrip
      223
    4. 4
      +FloatingFatMan
      196
    5. 5
      Steven P.
      137
  • Tell a friend

    Love Neowin? Tell a friend!