Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
svibuk
Yak Posting Veteran
62 Posts |
 Posted - 2013-02-16 : 06:23:45
|
| in asp.net i hve gridview with checkbox populated with data asselect d.id,d.name,d.age,h.height,p.photo from details dinner join m_height h on m.height=h.height inner join m_photo p on p.id=m.id the selected data[ checked data] from gridview is saved in another table sel_details as insert into sel_details(sid)values(checkedbox id)when the page is loaded next time i need that checkbox to be checked whose id is stored as sid in sel_details along with the rest of data |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-16 : 07:13:38
|
| this is not a sql question. this need to be done at frond end ie through asp.net code. from sql, you just need to retrieve the set detailsie select sid from sel_details------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
svibuk
Yak Posting Veteran
62 Posts |
Posted - 2013-02-16 : 07:58:09
|
| thankswas thinking if the 2 select stmts culd be combined to obtain the needed outputbut i think i need to do it seperately and retrive in front end |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-16 : 08:53:43
|
| yep...Indeed------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
combining 2 select stmts