What is the mostly used in sqlwebforms the sqldatasource control or the objectdatasource?

Question

0.00/5 (No votes)

See more:

hi
i am studing asp.net webforms and i went throught two controls the first one is the sqldatasource and the other is the objectdatasource but i am a liite confused about which one is mostly used in web form

on the other hand developers says that sqldatasource is bad because i can make conflicts in schemas spicially if the project is very big

can any one help me in that

What I have tried:

read more about both controls the sqldatasource and the objectdatasource

Posted 17-Mar-20 3:13am

Member 14479161

Updated 17-Mar-20 4:32am

Add a Solution

2 solutions

Solution 1

SqlDataSource is used when you are connecting to a Microsoft Sql Server. The ObjectDataSource is used when connecting to servers that are not Microsoft Sql server.

That is the basic difference.

Posted 17-Mar-20 3:20am

ZurdoDev

Comments

Richard Deeming 17-Mar-20 10:26am

Not quite.

SqlDataSource is used if you're connecting directly to SQL. ObjectDataSource is used if you're calling custom code to load the data.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Richard Deeming · Accepted Answer · 2020-03-17T04:33:00

The SqlDataSource control connects directly to a SQL Server database. The main problem with it is that you end up embedding your queries within the markup of your pages, which makes it difficult to keep your code clean.

Querying Data with the SqlDataSource Control (VB) | Microsoft Docs[^]

The ObjectDataSource control calls your custom code in other classes to access the data. This helps to keep the data access code separated from the presentation code.

Displaying Data With the ObjectDataSource (C#) | Microsoft Docs[^]

If you're using ASP.NET 4.5 or later, you can typically replace the ObjectDataSource control with model binding methods to keep your code even cleaner:

Model Binding and Web Forms in Visual Studio 2013 | Microsoft Docs[^]
ASP.NET 4.5 | Microsoft Docs[^]