• 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

    • XFX 9060 XT 16 GB is $349 on Amazon (shipped & sold by Amazon) https://www.amazon.com/dp/B0F8...p;previewDohDeal=1&th=1 People - never trust any neowin deals posted - they are the worst at seeking deals, and just want to peddle their own to make a quick buck. It's disgusting.
    • It's a grey market key - proceed at your own risk. It's baffling that neowin supports this shady stuff.
    • Arc 1.57.0 by Razvan Serea ARC browser is finally here for Windows, bringing its unique and modern approach to browsing. With a clean interface and a powerful sidebar, ARC makes managing tabs and organizing your workflow a breeze. You can group tabs, pin important pages, and quickly switch between work and personal spaces without clutter. It’s designed to be fast, customizable, and genuinely useful, making it more than just a browser—it’s a productivity tool. If you’re on Windows and want a fresh way to browse and stay organized, ARC is worth checking out. ARC browser key features: Split View: Work with multiple tabs side by side in a single window for efficient multitasking. Tab Grouping: Organize tabs into customizable groups for better workflow management. Pinned Tabs: Keep essential pages permanently accessible in the sidebar. Spaces: Create separate workspaces for different projects or personal use, reducing clutter. Sidebar Integration: Access bookmarks, notes, and tools directly from the sidebar for quick navigation. Customizable Themes: Personalize the browser’s appearance with themes and color schemes. Quick Search: Find tabs, history, or bookmarks instantly with a powerful search bar. Lightning-Fast Performance: Built for speed with optimized resource usage and minimal lag. Built-in Note-Taking: Jot down ideas or save snippets directly within the browser. Focus Mode: Hide distractions and focus on a single tab or task. Cross-Device Syncing: Seamlessly sync your data across multiple devices for a unified experience. Keyboard Shortcuts: Boost productivity with customizable shortcuts for common actions. AI-Powered Suggestions: Get smart recommendations for tabs, bookmarks, and workflows. Privacy Controls: Built-in tools for blocking trackers and managing cookies for enhanced security. Extensions Support: Compatible with popular browser extensions to extend functionality. Arc Browser 1.57.0 release notes: ''Thanks as always for using Arc. This week's release includes a bump to Chromium 137.0.7151.69, which patched three security vulnerabilities. Enjoy!'' Download: Arc Browser 1.57.0 | 1.9 MB (Freeware) View: Arc Browser Website | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • they put useless AI, new plastick sticker 8K and price +$80 for nothing
    • this AD block popup in annoying
  • Recent Achievements

    • First Post
      Uranus_enjoyer earned a badge
      First Post
    • Week One Done
      Uranus_enjoyer earned a badge
      Week One Done
    • Week One Done
      jfam earned a badge
      Week One Done
    • First Post
      survivor303 earned a badge
      First Post
    • Week One Done
      CHUNWEI earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      427
    2. 2
      +FloatingFatMan
      237
    3. 3
      ATLien_0
      213
    4. 4
      snowy owl
      207
    5. 5
      Xenon
      159
  • Tell a friend

    Love Neowin? Tell a friend!