[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.inetserver.asp.general

http://www.paddom.de/21.htmlyeqqxl

insinaipt

12/28/2013 9:01:00 AM

[url=http://www.paddom....]http://www.paddom....[/url]hsdr
cjufktsa
rnfaumft
opeykwdo
[url=http://www.paddom....]the north face evolution triclimate[/url]gvgr
rotnwndd
vqhkftkh
ictcgvha
[url=http://www.paddom....]the north face winterjacke[/url]tyjj
qwwoqxok
spfqqnor
tovnldvl
[url=http://www.paddom....]http://www.paddom....[/url]imur
cilrkedv
delolsvz
zlxfpuyl
[url=http://www.paddom....]the north face[/url]czkz
aitnwkpy
pmkwould
eacqafbq
ryhnjamt
zzscnpxh
zaptrask
rjcvcmvr
2 Answers

v-wywang

11/8/2007 10:10:00 AM

0

Hello Madison,
Thanks for your reply.

I'm sorry, maybe I mislead you. DataSource control only supports one record
set. We cannot retrieve multiple record sets with it.
What I mean is that I prefer Coding to DataSource Control. As Bill said,
using one SQLCommand call to retrieve all record sets from underlying
database is a good way. (Just as what you did) We can store the dataset
returned by SQLDataAdapter into Page.ViewState. When postback happens, we
get all records from ViewState, filter it by DataTableView, and bind them
to drop list box. That's fine.

However, if we choose SQLDataSource, it will save us much time on coding.
We can just drag-drop five SqlDataSource controls into page, set select
command/ parameter for each of them, and bind them to dropdownlist
controls. But there will be a performance issue. SqlDataSource will call
underlying DB, each time its parameter changed. For example: if end user
selects another option in (sector) dropdownlist, this will force two
sqldatasource controls (business type and building type) to call its
underlying DB. Thus, customer need wait a long time for this operation.

If you'd like to see some sample with SqlDataSource, you may refer to
http://www.asp.net/learn/data-access/tutorial-...

Hope this helps, please feel free to update here again, if there is
anything unclear. It's my pleasure to assist you.
Have a great day,
Best regards,

Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

v-wywang

11/12/2007 11:42:00 AM

0

Hello Madison,

This is Wen Yuan, again. I just want to check if there is anything we can
help with.
Please feel free to update here, if you have any more concern. We are glad
to assist you.

Have a great day,
Best regards,

Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.