Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL .NET SQL-Server , +
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 29-Nov-12 21:37pm
Edited 29-Nov-12 21:39pm
__TR__29K
v2
Comments
Krunal R at 30-Nov-12 3:16am
   
As per my opinion, 5. SP is best :)

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.
  Permalink  

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



Advertise | Privacy | Mobile
Web01 | 2.8.150327.1 | Last Updated 30 Nov 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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