Click here to Skip to main content
12,693,891 members (32,970 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# VB 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
Updated 29-Nov-12 21:39pm
Krunal R 30-Nov-12 3:16am
As per my opinion, 5. SP is best :)

1 solution

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

Solution 1


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 | Mobile
Web02 | 2.8.170118.1 | Last Updated 30 Nov 2012
Copyright © CodeProject, 1999-2017
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