Some Basic Differences Between ASP.NET 2.0 ObjectDataSource and SqlDataSource

* Type Name
For ObjectDataSource, the property TypeName includes the class name, that will responsible to manage data, this may NOT be the data object collection. The select, insert etc methods will use the mentioned methods to access or retrieve data. For SqlDataSource, a built-in data collection is used, which can be bound to data data controls.

* Connection String
For ObjectDataSource, there is NO connection string needed, as it is used middle tier. For SqlDataSource, connection string is needed.

* CRUD Method
For ObjectDataSource, there is NO method (select, insert etc) type, as the methods are being used from a class of middle tier. For SqlDataSource, there are two types of methods StoredProcedure and Text. note, in SqlDataSource, for parameters, in the execution time the system automatically includes a '@' before the name as specified in the name property.

kick it on
Print | posted on Wednesday, November 15, 2006 10:59 PM


# Basic Differences Between .NET 2.0 ObjectDataSource and SqlDataSources

left by at 12/9/2006 3:32 AM Gravatar
You've been kicked (a good thing) - Trackback from

# re: Some Basic Differences Between ASP.NET 2.0 ObjectDataSource and SqlDataSource

left by prakash kumar pothal at 8/29/2008 5:04 PM Gravatar
Thank u .i am a fresher means i completed my mca from utkal university(2008).i have some doubt on ObjectDataSource and SqlDataSource.but when i was reading ur articles i just relax.if possible plz give me some good samples on that in my email address or any code which is useful for me.becz i am working in software company.

With Regards & Thanks
Post A Comment