ASP.NET

BoundFields with different DataSources

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Dec 2008

Posts: 19

Reputation: dfs3000my is an unknown quantity at this point

Solved Threads: 0

dfs3000my

Offline

Newbie Poster

BoundFields with different DataSources

Oct 29th, 2009

I'm currently populating my GridView using code-behind codes and it looks like this:-

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
BoundField boundField = new BoundField();
boundField.DataField = "student_name";
boundField.HeaderText = "Name";
GridView1.Columns.Add(boundField);
BoundField boundField = new BoundField();
boundField.DataField = "student_name";
boundField.HeaderText = "Name";
GridView1.Columns.Add(boundField);

Is there a possibility where I can have a different DataSource for the different BoundFields that I insert?

Perhaps, Column 1 - 5 uses SQLDataSource1, Column 6 uses SQLDataSource2, and Column 7 uses SQLDataSource3

Last edited by dfs3000my; Oct 29th, 2009 at 2:31 am.

•

Join Date: Jun 2009

Posts: 449

Reputation: Ramesh S will become famous soon enough

Solved Threads: 82

Ramesh S

Offline

Posting Pro in Training

Oct 30th, 2009

You cannot assigne multiple data sources such as DataTables, SqlDataSources to the bound columns in a GridView. The data source should come from a single object.

If your want to retrieve records from different database tables which reside in different servers, you need to write some logic to fetach data from different database servers/tables, store it in temprory tables and combine them into single DataTable and assigne them to GridView.