Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
gridview for two tables
0 views
Skip to first unread message
E. Kwong
Aug 26, 2008, 3:22:47 PM8/26/08
to
I have a SQL select command that draws data from two table. Data from
table1 is for display only, while data from table2 is allowed for edit and
deletion. I would like to know whether gridview is good for this kind of
requirement, or if other control is more appropriate. Specifically, can
columns from table1 be configurated non-editable and non-deletable in the
gridview control?
table1 is for display only, while data from table2 is allowed for edit and
deletion. I would like to know whether gridview is good for this kind of
requirement, or if other control is more appropriate. Specifically, can
columns from table1 be configurated non-editable and non-deletable in the
gridview control?
Thanks.
Eliyahu Goldin
Aug 31, 2008, 9:06:27 AM8/31/08
to
Yes, sure, but you will still need to join the tables in the same recordset.
If you use template columns, you can databind item template to one set of
fields and edit template to another. With datasource controls you specify
separate sqls for selecting, deleting, inserting and updating, so it is easy
to operate on different tables.
If you use template columns, you can databind item template to one set of
fields and edit template to another. With datasource controls you specify
separate sqls for selecting, deleting, inserting and updating, so it is easy
to operate on different tables.
--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"E. Kwong" <ekwong999AThotmail.com> wrote in message
news:OR3QgE7B...@TK2MSFTNGP02.phx.gbl...
0 new messages