Click here to Skip to main content
11,803,019 members (52,749 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: C# ASP.NET
Hi Friends I need an help

How to use multiple dataset in a single grid view using
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...

Sushil Dharmar
Posted 19-Apr-12 4:41am
Edited 19-Apr-12 5:04am
RDBurmon at 19-Apr-12 10:43am
Can you share structure of your datasets ?
Mark Nischalke at 19-Apr-12 10:54am
The data structure is irrelevant
Mark Nischalke at 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.
Sushil_Sri at 19-Apr-12 11:03am
ok Mark..
Rate this: bad
Please Sign up or sign in to vote.

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.
Sushil_Sri at 19-Apr-12 11:06am
can we use any other data controls either than gridview..?
Mark Nischalke at 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
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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,
Sushil_Sri at 21-Apr-12 22:51pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

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();
GridView1.DataSource = ds;
CHill60 at 29-Apr-14 12:40pm
OP wanted to use multiple datasets. This only covers a single dataset. And it's a year too late on an already answered post

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

  Print Answers RSS
0 OriginalGriff 335
1 KrunalRohit 291
2 F-ES Sitecore 270
3 CPallini 270
4 Sergey Alexandrovich Kryukov 234
0 OriginalGriff 2,950
1 Maciej Los 1,910
2 KrunalRohit 1,862
3 CPallini 1,735
4 Richard MacCutchan 1,157

Advertise | Privacy | Mobile
Web04 | 2.8.151002.1 | Last Updated 29 Apr 2014
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100