Welcome Guest Search | Active Topics | Sign In | Register

Grid with multiple table data source Options
Hub
Posted: Tuesday, March 16, 2010 10:08:12 AM
Rank: Advanced Member
Groups: Member

Joined: 3/16/2010
Posts: 101
Hi,

"first time caller".

I could not find the place in the doc or samples where the topic of grid with multiple sql data sources (or one linqdatasource) is documented. Could you please point me in the right direction (where I can hopefully find some explanation and examples).

Thanks
eo_support
Posted: Tuesday, March 16, 2010 10:23:59 AM
Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194
Hi,

Thanks for posting in the forum. You will have to join your tables together in your SQL in that case. The Grid is two dimensional so it doesn’t matter where you data come from, in the end you have to give it a single two dimensional data set.

Thanks!
Hub
Posted: Tuesday, March 16, 2010 11:38:36 AM
Rank: Advanced Member
Groups: Member

Joined: 3/16/2010
Posts: 101
Impressive response time!

Ok, so there is no equivalent to the ASP gridview templatefield in which one can deal with multiple sqldatasources (I thought that maybe the dataformat could have been used for that....)

Thanks for your very quick answer.
eo_support
Posted: Tuesday, March 16, 2010 11:47:48 AM
Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194
Hi,

That is correct. There is no equivalent of TemplateField because our Grid is very much a client side grid, where ASP.NET GridView is a server Grid. You can not nest Grid with our Grid either. The main advantage of our Grid is that it doesn't go back to the server when you edit a cell.

The online documentation should be the good start point for you if you are not familiar with our Grid:

http://doc.essentialobjects.com/library/1/grid/start.aspx

It's very different than the ASP.NET GridView that you are used to. :)

Thanks!
Hub
Posted: Tuesday, March 16, 2010 11:52:52 AM
Rank: Advanced Member
Groups: Member

Joined: 3/16/2010
Posts: 101
Yes, I did use the client side features already and that makes for a great user experience.

Thanks.
eo_support
Posted: Tuesday, March 16, 2010 11:58:09 AM
Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194
You are very welcome. Just an additional note, the DataFormat property is used on the client side as well. The Grid uses that property to format "cell value" and then show the formatted result inside the cell. For example, showing images inside a cell is usually done this way by "formatting" an image Url into an img tag. It still has nothing to do with multiple data source though.

Thanks!


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.