How to read the dataset values

Question

1.00/5 (1 vote)

See more:

here is my code i read a XML doc and get all their values in dataset, how to take that all dataset values in gridview. i need the output like the same dataset visualizer.

C#

XmlDocument doc = new XmlDocument();
            doc.Load(PATH);
            
            DataSet ds = new DataSet();
            ds.ReadXml(PATH);

Posted 28-May-13 19:02pm

kesav prakash

Updated 28-May-13 19:38pm

_Amy

v4

Add a Solution

Comments

Mac12334 29-May-13 1:35am

You want to show the dataset value in ASP.NET Gridview ???? or you want to read the dataset value??

3 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)

_Amy · Answer 1 · 2013-05-28T19:38:00

Set the datasource of GridView to dataset.

C#

GridView1.DataSource = ds;
GridView1.DataBind();

Refer the links for similar example:
Bind Gridview with XML String using DataSet[^]
How to bind an XML file to a GridView[^]
Bind XML to Grid view in asp.net[^]
ASP.NET: How to use an XMLDataSource with a GridView[^]

--Amit

sainadh.chintha · Answer 2 · 2013-05-28T19:59:00

Solution 3

C#

GridView1.DataSource =ds.Tables[0];
GridView1.DataBind();

Posted 28-May-13 19:59pm

sainadh.chintha

Aravindba · Answer 3 · 2013-05-28T19:12:00

Solution 1

Hi Change to datatable and u read like this

C#

foreach (DataRow row2 in ds.Rows) {
	string a = null;
	a = row("fieldname").ToString();
}

Posted 28-May-13 19:12pm

Aravindba

Updated 28-May-13 20:51pm

v2

Comments

kesav prakash 29-May-13 1:19am

what i need to give in that fieldname. its a table name or someother else

kesav prakash 29-May-13 1:23am

a = row("fieldname").ToString();
also canu tell me what is the row here.

Aravindba 29-May-13 23:23pm

just use break point and see what are the fields in ds ,in ds it show row and column ,and take header of the column as field.

a = row("field").ToString();

just see link posted by Amit .second link "How to bind an XML file to a GridView" in that first image show one table,same like u get in ds,the header of the coloum is id,name and phone is field,use that field .

foreach (DataRow aaa in ds.Rows) {
string a = null;
a = aaa("fieldname").ToString();
}

if ds have multipls row it retrive from ds by using aaa.