• 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

    • I thought router has to have 6 Ghz band to be called wifi-7, guess I was wrong...
    • I have the Pixel 9 Pro XL...Unless this thing is "leaps and bounds" faster than the 9, I'll pass. And by leaps and bounds, I don't mean on benchmarks. "Real world" faster. Most people don't even come close to topping out the performance of their phones. Tensor G5 is Google's most powerful chip to date, boasting a staggering 36 percent performance leap over G4.
    • MIT's stunning 'bubble wrap' device squeezes water out from thin air even in deserts by Sayan Sen Image by Matteo Roman via Pexels Massachusetts Institute of Technology (MIT) engineers have built a new kind of device that can pull clean drinking water straight out of the air—no electricity needed. It’s designed for areas where water is scarce and traditional sources like rivers or lakes aren’t reliable. Right now, more than 2.2 billion people globally don’t have access to safe drinking water. In the United States alone, 46 million face water insecurity, with either no running water or water that’s not safe to drink. This new device, called an Atmospheric Water Harvesting Window (AWHW), uses a unique hydrogel panel that looks like black bubble wrap. These dome-shaped bubbles soak up water vapor from the air, especially at night when humidity is higher. During the day, sunlight makes the vapor inside evaporate. That vapor then condenses on a glass surface and drips down through a tube, turning into drinkable water. The AWHW doesn’t rely on power sources like batteries or solar panels. It’s completely passive, meaning it works on its own. The team tested a meter-sized panel in Death Valley, California, one of the driest places in North America, and got between 57.0 and 161.5 milliliters of water per day even with humidity as low as 21 percent. That’s more than what other similar passive devices have managed. “We have built a meter-scale device that we hope to deploy in resource-limited regions, where even a solar cell is not very accessible,” said Xuanhe Zhao, a professor at MIT. “It’s a test of feasibility in scaling up this water harvesting technology. Now people can build it even larger, or make it into parallel panels, to supply drinking water to people and achieve real impact.” Another cool part of the design is how they kept the water safe to drink. Usually, these kinds of hydrogels use salts like lithium chloride to absorb more vapor but that can lead to salt leaking into the water, which isn’t ideal. To solve this, MIT’s team mixed in glycerol, a compound that helps keep salt locked inside the gel. In testing, the lithium ion concentration in the harvested water stayed below 0.06 ppm (parts per million), which is way below the safe limit. The hydrogel domes also give the material more surface area, letting it collect more vapor. The outer glass panel is coated with a special polymer film that helps cool the glass, making it easier for vapor to condense. “This is just a proof-of-concept design, and there are a lot of things we can optimize,” said lead author Chang Liu, now a professor at the National University of Singapore. “For instance, we could have a multipanel design. And we’re working on a next generation of the material to further improve its intrinsic properties.” Published in Nature Water, the study says the AWHW could last at least a year and shows promise for making safe, sustainable water in places with harsh climates. The researchers believe an array of vertical panels could one day supply water to individual households, especially in remote or off-grid locations. Source: MIT News, Nature This article was generated with some help from AI and reviewed by an editor. Under Section 107 of the Copyright Act 1976, this material is used for the purpose of news reporting. Fair use is a use permitted by copyright statute that might otherwise be infringing.
    • Clear Linux is open source, indeed, so its source code is available for anyone. They're just shutting down its support from them, they're not forbidding anyone else from taking over.
    • Linux Mint is also my favorite distro, but I fear what will happen with it if Clem were to disappear tomorrow, to be honest.
  • Recent Achievements

    • First Post
      leoniDAM earned a badge
      First Post
    • Reacting Well
      Ian_ earned a badge
      Reacting Well
    • One Month Later
      Ian_ earned a badge
      One Month Later
    • Dedicated
      MacDaddyAz earned a badge
      Dedicated
    • Explorer
      cekicen went up a rank
      Explorer
  • Popular Contributors

    1. 1
      +primortal
      505
    2. 2
      ATLien_0
      209
    3. 3
      Michael Scrip
      202
    4. 4
      Xenon
      144
    5. 5
      +FloatingFatMan
      121
  • Tell a friend

    Love Neowin? Tell a friend!