470,561 Members | 2,183 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,561 developers. It's quick & easy.

Need advice on datagridview alternative

I have a web page that uses a DataGridView to display data from an SQL
database. I have added a lot more fields to the SQL database but don't want
to have have an extremely wide DataGrid.

What I'd like to do is have a listing of the basic information for each
record, then the user can click on a record to expand the detailed
information for that record.

I'd like to do this using native VWD components. I don't want to use any 3rd
party stuff. Can anyone give some advice on what can do this or how to do
it?

Thanks!
Sep 3 '06 #1
3 1606
Bob
You can get a full source here:
VB:
http://download.microsoft.com/downlo...Lesson08VB.msi
C#:
http://download.microsoft.com/downlo...Lesson08CS.msi
You can download all lesson's movies and example sources here :
http://msdn.microsoft.com/vstudio/ex...g/default.aspx
Something you need is lesson 8.

Good luck.

Terry Olsen wrote:
I have a web page that uses a DataGridView to display data from an SQL
database. I have added a lot more fields to the SQL database but don't want
to have have an extremely wide DataGrid.

What I'd like to do is have a listing of the basic information for each
record, then the user can click on a record to expand the detailed
information for that record.

I'd like to do this using native VWD components. I don't want to use any 3rd
party stuff. Can anyone give some advice on what can do this or how to do
it?

Thanks!
Sep 3 '06 #2
One of the options is to have the datagrid with all columns, both the basic
and the details, but to make only the basic visible. The details will be
hidden. You can have a separate panel on the form where you can place the
details for the currently selected row. You will need to write some
javascript to set the detail controls on the panel to the values of the
hidden columns.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"Terry Olsen" <to******@hotmail.comwrote in message
news:um*************@TK2MSFTNGP05.phx.gbl...
>I have a web page that uses a DataGridView to display data from an SQL
database. I have added a lot more fields to the SQL database but don't want
to have have an extremely wide DataGrid.

What I'd like to do is have a listing of the basic information for each
record, then the user can click on a record to expand the detailed
information for that record.

I'd like to do this using native VWD components. I don't want to use any
3rd party stuff. Can anyone give some advice on what can do this or how to
do it?

Thanks!

Sep 3 '06 #3
Terry,
Probably the easiest way to handle this is to have the ID column displayed
with a Hyperlink control, which would point to either the same page with the
id on the querystring, or to a separate detail page (can be a popup window).
You would then use a second grid, DataList or similar control which would
accept the ID from the querystring and display complete details of the single
row - all fields, in a table.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Terry Olsen" wrote:
I have a web page that uses a DataGridView to display data from an SQL
database. I have added a lot more fields to the SQL database but don't want
to have have an extremely wide DataGrid.

What I'd like to do is have a listing of the basic information for each
record, then the user can click on a record to expand the detailed
information for that record.

I'd like to do this using native VWD components. I don't want to use any 3rd
party stuff. Can anyone give some advice on what can do this or how to do
it?

Thanks!
Sep 3 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Peter | last post: by
2 posts views Thread by mark carew | last post: by
3 posts views Thread by martin1 | last post: by
reply views Thread by James | last post: by
2 posts views Thread by ManjuG | last post: by
8 posts views Thread by Izzy | last post: by
5 posts views Thread by ElPresidente | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.