0

I am learning ASP.NET. I noticed there are several types of ASP.NET data source controls available in Microsoft Visual studio, including SqlDataSource, AccessDataSource, ObjectDataSource, and XmlDataSource. Does anyone could explain the differences among SqlDataSource, AccessDataSource, ObjectDataSource, and XmlDataSource? Which one is more useful in the real world? Thank you.

1
  • a quick internet search would answer this... Commented Feb 2, 2013 at 4:03

4 Answers 4

1

go through this links, it helped me. Hope it will help you too.

Data Source Controls and Connections
ASP.NET Data Sources

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you for sharing these websites. they are very useful and clear.
0

I used sqldatasources a little, but now, just use entity framework. I was (still am) getting data from a sql db.

Comments

0

mrqyue, You can try this

This will explain more clearly about what you are looking for..

Moreover, try this. It will explain with examples

Comments

0

You choose XMLDataSource if you connect to an XML file. You choose AccessDataSource if your source of data is from Access database. You choose SqlDataSource if you connect to any data source that has an ADO.NET data provider (SQL Server, Oracle, OLEDB, ODBC). You choose ObjectDataSource if you want to connect to a custom object to fetch/take data from the database (a very efficient way for a medium-to-large application).

Most of my projects are using N-Tier architecture and my best option is always ObjectDataSource. It gives my team a freedom to work independently, but simultaneously in one big project!

I hope it helps you.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.