• 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

    • Ah .. lockout for suspicious activity. I bet they uploaded the SanDisk utility detected as malware
    • Microsoft 365 will soon disable outdated authentication protocols for file access by Usama Jawad On a fairly regular basis, Microsoft disables outdated protocols that are used to access its services. In the past few years, the company has deprecated Basic Auth in Exchange Online and cut access to Outlook for third-party apps relying on this protocol. Now, it has decided to get rid of old authentication protocols for file access across Microsoft 365 services. As reported by Bleeping Computer, Microsoft has posted a message on its Microsoft 365 Admin Center. Starting from mid-July 2025, the company will begin disabling legacy authentication protocols used to access files across Microsoft 365 and Office apps, SharePoint, and OneDrive. Essentially, applications or services which use the Relying Party Suite (RPS) or FrontPage Remote Procedure Call (FPRPC) will to perform browser-based authentication to perform open operations on Office files will no longer be able to do so. As expected, this is primarily being done to improve the cybersecurity posture of various services. Microsoft states that RPS can be brute-forced and phished with relative ease as it is fairly outdated. Similarly, FPRPC is typically used for remote web page authoring and it is susceptible to exploitation through various vulnerabilities too. As such, both of these protocols will be disabled by default starting from mid-July 2025, with the rollout of this change targeting completion by August 2025. The Redmond tech giant will update the protocol baseline by default without mandating any licensing changes for customers. In addition, once these modifications are rolled out, Microsoft 365 will require admin consent to get third-party access to files and sites. IT admins can view the guidance available here to configure admin consent workflows. Microsoft says that these changes align with the principles of its Secure Future Initiative (SFI). Earlier today, it announced the rollout of improved security defaults for Windows 365 citing the same reasons too.
    • This is how you kill your own business.
    • It does and it can... I took an i3 board and upgraded it to my FX8350... no issues, just put in new drivers over the top that Windows didn't. Not the issue for me, (though I eventually did do a new install from 23H2 to 24H2)... I was on 22H2 at the time. The issue is activation. You may get hit with having to activate again.
  • Recent Achievements

    • First Post
      Fuzz_c earned a badge
      First Post
    • First Post
      TIGOSS earned a badge
      First Post
    • 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
  • Popular Contributors

    1. 1
      +primortal
      705
    2. 2
      ATLien_0
      283
    3. 3
      Michael Scrip
      217
    4. 4
      +FloatingFatMan
      195
    5. 5
      Steven P.
      130
  • Tell a friend

    Love Neowin? Tell a friend!