Bind multiple dataset in a gridview using asp.net

Question

4.00/5 (1 vote)

See more:

Hi Friends I need an help

How to use multiple dataset in a single grid view using asp.net
For egs: the first 3 three cells is filled wid one dataset and the rest with other dataset..
If so den how...
is there any other solution either than this...

Regards
Sushil Dharmar

Posted 19-Apr-12 4:41am

SushilDharmar

Updated 19-Apr-12 5:04am

v3

Add a Solution

Comments

RDBurmon 19-Apr-12 10:43am

Can you share structure of your datasets ?

[no name] 19-Apr-12 10:54am

The data structure is irrelevant

[no name] 19-Apr-12 10:55am

Don't ask for urgent help, it is very rude. This is a volunteer site and people will answer on their time, not yours. Bluntly, it may be urgent to you, but not to anyone here.

SushilDharmar 19-Apr-12 11:03am

ok Mark..

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)

Not Active · Answer 1 · 2012-04-19T04:56:00

Solution 1

The grid can only be bound to one DataSource so you would need to either merge them or construct one with the elements necessary.

Posted 19-Apr-12 4:56am

Not Active

Comments

SushilDharmar 19-Apr-12 11:06am

can we use any other data controls either than gridview..?

[no name] 19-Apr-12 13:46pm

You can use any control you'd like, but they all only accept a single DataSource.
If you want more then you'll need to write it yourself

Reza Ahmadi · Answer 2 · 2012-04-19T05:07:00

Solution 2

Hi,
You need to merge those datasets and bind the resulting dataset to your control, take a look at this post:
how to merge two data set[^]

I hope it helps,
Cheers

Posted 19-Apr-12 5:07am

Reza Ahmadi

Comments

SushilDharmar 21-Apr-12 22:51pm

ok.....

Akib B. Momin · Answer 3 · 2014-04-29T05:50:00

Hi Friends....
Code for Binding Dataset to Grid View
---------------------------------------------------
SqlConnection con = new SqlConnection(" xyz");
string str = "select colmn1,colmn2 from tablename";
SqlDataAdapter da = new SqlDataAdapter(str,con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
---------------------------------------------------
Enjoy......

Bind multiple dataset in a gridview using asp.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us