To ask about the dataset usage

Question

0.00/5 (No votes)

See more:

Hi,,

I want to know about usage of the dataset and

C#

public DataSet getTestList (string procedurename);

here data set used as some type what it means I didn't understand?
Please anybody.. help me

Posted 13-Jul-12 22:59pm

Member 9073926

Updated 13-Jul-12 23:03pm

Sebastian T Xavier

v2

Add a Solution

Comments

Sebastian T Xavier 14-Jul-12 5:03am

Its is pretty interesting that, you didn't understand this....

Kenneth Haugland 14-Jul-12 5:04am

Im having a hard time to figure out what you actually are asking about. Could you give some code, or clearify the example ?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sebastian T Xavier · Answer 1 · 2012-07-13T23:06:00

Hi,

Hope you are not afraid of the search engine called google!!!!!!

The ADO.NET DataSet contains DataTableCollection and their DataRelationCollection . It represents a complete set of data including the tables that contain, order, and constrain the data, as well as the relationships between the tables.

We can use Dataset in combination with DataAdapter Class . Build and fill each DataTable in a DataSet with data from a data source using a DataAdapter. The DataSet object offers a disconnected data source architecture. The Dataset can work with the data without knowing the source of the data coming from. That is , the Dataset can work with a disconnected mode from its Data Source . It gives a better advantage over DataReader , because the DataReader is working only with the connection oriented Data Sources.

The Dataset contains the copy of the data we requested. The Dataset contains more than one Table at a time. We can set up Data Relations between these tables within the DataSet. The data set may comprise data for one or more members, corresponding to the number of rows.

The DataAdapter Object allows us to populate DataTables in a DataSet. We can use Fill method of the DataAdapter for populating data in a Dataset. The DataSet can be filled either from a data source or dynamically. A DataSet can be saved to an XML file and then loaded back into memory very easily. A DataSet can read and write data and schema as XML documents. The data and schema can then be transported across HTTP and used by any application, on any platform that is XML-enabled.

Here are some useful links

http://csharp.net-informations.com/dataset/csharp-dataset-sqlserver.htm[^]

http://www.dotnetperls.com/dataset[^]

http://msdn.microsoft.com/en-us/library/system.data.dataset(v=vs.71).aspx[^]

C#

public DataSet getTestList (string procedurename);

In the abovecode , You are tying to call a method called getTestList with a string type input parameter and the return type is Dataset.

Hope you are clear!!!...

Regards
Sebastian

Richard MacCutchan · Answer 2 · 2012-07-13T23:07:00

Solution 2

See the documentation on MSDN[^] for details of all .NET classes. You can also try a search of the CodeProject Articles[^] for samples.

Posted 13-Jul-12 23:07pm

Richard MacCutchan