Click here to Skip to main content
0 members
Rate this:
 
Please Sign up or sign in to vote.
There are many ways we can bind data from sql to aspx page.
1. using dataset
2. sqldatasourse or entitydatasource to datacontrol
3. for datacontrols with back end coding
4. datacontrols with automatic updation, deletion..etc
5. in back end connected-disconnected mode with query.
5. using stored procedure
any many more...

So what is the actual best way or the industry thinks its the proper way of coding for software developer and why?????
Posted
Updated 29-Nov-12 20:39pm
v2

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Hi,

Each option has their own advantages and disadvantages.

And we should use as per our requirement.

SP is best because it keeps compile code, So it is efficient and fast.
Use DataReader if you only want fwd read access of data.
Use DataSet if you want to modify the changes and fwd as well as backward or multiple traverse of data.

Entity Framework / LINQ to SQL / nHibernate gives good performance some time.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Cookies | Terms of Service
Web03 | 2.8.190419.4 | Last Updated 30 Nov 2012
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100