Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 23rd, 2008, 04:00 PM
Authorized User
Join Date: Sep 2004
Posts: 68
Thanks: 1
Thanked 0 Times in 0 Posts
Default Best Data Source Control to Use in ASP.Net 2.0


I'm a veteran classic asp and ado programmer and am now learning asp.net and ado.net. I'm trying to determine the best data source control to use for my asp.net apps. It seems i have three choices: sqlDataSource, xmlDataSource and objectDataSource.

sqlDataSource seems easy to use, but has stated limitations. I'm looking for the one to use for large web applications and one that will provide the highest degree of security (to prevent injection attacks, etc.).

Which one would you recommend?

Thank you for your help.

Old January 23rd, 2008, 04:07 PM
Wrox Author
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons

Personally, I don't use those DataSources objects except in very specific situations. I create a Data Logic Layer(DLL) that handles my data needs and then bind controls to some sort of strong typed Data Source like a List<T>.

I find that this is the most Robust approach but also requires more coding on your part then simply dragging and dropping Data Source controls so I guess it depends on where your comfort zone lies.

My two cents anyway.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========
Old January 23rd, 2008, 05:30 PM
Imar's Avatar
Wrox Author
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts

Hi there,

Take a look at the article series about N-Layer design that starts here:


It discusses the SqlDataSource and ObjectDataSource controls and shows you a real-world example of the latter. You can still do what Doug suggests (create your own code layers), but use the DataSource controls in the front end for code free data binding....

Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Similar Threads
Thread Thread Starter Forum Replies Last Post
help me with source code of Asp.net E-commerce... susanfletcher ASP.NET 1.0 and 1.1 Basics 1 October 18th, 2008 09:20 AM
ASP.NET control to encrypt data ? ScottHW ASP.NET 2.0 Basics 2 September 14th, 2007 07:53 AM
can't setup Professional ASP.NET 1.0 source code gologo ASP.NET 1.0 and 1.1 Basics 0 December 11th, 2006 07:47 AM
Data source control for Create User zoltac007 BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 13 August 16th, 2006 02:34 PM
Help 'beginning asp.net using vb.net' source code jkmf Wrox Book Feedback 1 January 18th, 2004 08:09 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.