Solved

DataSet / Filling DataSet?

Posted on 2016-08-24
1
39 Views
Last Modified: 2016-08-25
I'm using vb.net / winforms.
I created a DataSetfor for some tables on a SQL Server. On the form the DataSet shows on the bottom. When I go into it (Edit in DataSet Designer) I see the table columns and bellow it TableAdapter, bellow that I see SQL Fill, GetData().
What is this Fill and GetDAte()? If they are methods to load the data, how do I call them from my code? As is, when I check this DataSet it contains now data.
0
Comment
Question by:Jess31
1 Comment
 
LVL 12

Accepted Solution

by:
Ramkisan Jagtap earned 500 total points
ID: 41769866
Check the following example to fill:

Dim northwindDataSet As New NorthwindDataSet()
Dim customersTableAdapter As New NorthwindDataSetTableAdapters.CustomersTableAdapter()

customersTableAdapter.Fill(northwindDataSet.Customers)

Open in new window


Reference:
https://msdn.microsoft.com/en-us/library/ms233822.aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1
https://msdn.microsoft.com/en-us/library/ms171919.aspx
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question