Click here to Skip to main content
15,919,879 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Webservice object parameters from seperate assembly Pin
bradz1513-Mar-07 5:49
bradz1513-Mar-07 5:49 
Questionhow to get text from captcha image Pin
uday_kiran13-Mar-07 2:19
uday_kiran13-Mar-07 2:19 
AnswerRe: how to get text from captcha image Pin
badgrs13-Mar-07 2:46
badgrs13-Mar-07 2:46 
AnswerRe: how to get text from captcha image Pin
Sandeep Akhare13-Mar-07 2:56
Sandeep Akhare13-Mar-07 2:56 
QuestionI need your Opinion about this matter Pin
blitz2bleach13-Mar-07 2:17
blitz2bleach13-Mar-07 2:17 
AnswerRe: I need your Opinion about this matter Pin
Guffa13-Mar-07 7:08
Guffa13-Mar-07 7:08 
QuestionFormView Pin
Tyrone_whitey13-Mar-07 2:05
Tyrone_whitey13-Mar-07 2:05 
QuestionWhat is the point of using .NET data sources? Pin
DaveRRR13-Mar-07 1:56
DaveRRR13-Mar-07 1:56 

What is the point of using data sources such as SqlDataSource or ObjectDataSource?


Consider a simple example of a web page with a dropdown list used to filter the content of a pageable, sortable GridView. Each control needs a data source and that results in two calls to SQL Server. We are also told to keep the number of "round trips" to SQL Server to a minimum, for best performance. These scenarios are incompatible (although the difference in my example is trivial).


The only solution I have spotted is to make a single call to a compound SQL Server stored procedure and to put the results in a dataset (a repeater cannot be used for a pageable, sortable GridView) and bind each control to the appropriate table in the dataset. The disadvantage to this method is that I now have to code the GridView Sorting and PageIndexChanging events rather than just supplying attributes for that control.


Dave


AnswerRe: What is the point of using .NET data sources? Pin
kubben13-Mar-07 3:06
kubben13-Mar-07 3:06 
QuestionResizing table Pin
Jeeva Mary Varghese13-Mar-07 1:44
Jeeva Mary Varghese13-Mar-07 1:44 
AnswerRe: Resizing table Pin
mareers13-Mar-07 1:55
mareers13-Mar-07 1:55 
QuestionHow to pass parameters to Sub Report from Main Report ? Pin
prakash_21013-Mar-07 1:34
prakash_21013-Mar-07 1:34 
QuestionImagebuttons Pin
nclauder13-Mar-07 1:32
nclauder13-Mar-07 1:32 
QuestionExtracting web page using ASP Pin
Imthu13-Mar-07 1:27
Imthu13-Mar-07 1:27 
AnswerRe: Extracting web page using ASP Pin
Sandeep Akhare13-Mar-07 2:27
Sandeep Akhare13-Mar-07 2:27 
QuestionInvoking a datagrid from a "background thread"?? Pin
Nada Adel13-Mar-07 1:25
Nada Adel13-Mar-07 1:25 
Questionhow to send alerts/messages from server to clients Pin
dotnethunk13-Mar-07 1:15
dotnethunk13-Mar-07 1:15 
AnswerRe: how to send alerts/messages from server to clients Pin
badgrs13-Mar-07 2:43
badgrs13-Mar-07 2:43 
QuestionHow to increase CrystalReportViewer ToolBar horizental length/width using .NET Pin
Elena200613-Mar-07 0:26
Elena200613-Mar-07 0:26 
Questionusing file uploader in a gridview Pin
chathu03j12-Mar-07 23:53
chathu03j12-Mar-07 23:53 
AnswerRe: using file uploader in a gridview Pin
kubben13-Mar-07 3:36
kubben13-Mar-07 3:36 
QuestionError in deleting a file !!! Pin
amin_behzadi12-Mar-07 23:52
professionalamin_behzadi12-Mar-07 23:52 
AnswerRe: Error in deleting a file !!! Pin
Paddy Boyd13-Mar-07 0:37
Paddy Boyd13-Mar-07 0:37 
GeneralRe: Error in deleting a file !!! Pin
amin_behzadi13-Mar-07 1:01
professionalamin_behzadi13-Mar-07 1:01 
QuestionMsg is not displaying when a Enter Email that is already in Database Pin
siddisagar12-Mar-07 23:24
siddisagar12-Mar-07 23:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.