DataSource and DatasourceId

Question

0.00/5 (No votes)

See more:

In C# code "DataSource" is been used and in asp "Datasourceid"
when i run the application it generate error that only one definition should be used. so when i eliminate dataSourceId or DataSource it generates that some Columns don't Exsist with such id.

What is the solution this. as code already has been designed in such a way that it requires both and i have been asked to update it..

Now i am stuck.....

Posted 25-Sep-13 22:07pm

hira_1

Add a Solution

Comments

saguptamca 26-Sep-13 4:11am

provide some code, what r u trying to say

3 solutions

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)

santosh1520 · Answer 1 · 2013-09-25T22:12:00

Solution 1

They can be used interchangeably, but you have to use carefully. e.g. If you first assign dataSourceID and then want to use DataSource, then before using DataSource, you have to clear the datasourceID by setting ControlID.DataSourceID = ""

Posted 25-Sep-13 22:12pm

santosh1520

**Azee** · Answer 2 · 2013-09-25T22:19:00

Hello mate,

DataSourceID is used in case you have used Asp.net DataSource controls e.g. ObjectDataSource etc. on your page to fetch data for your DataBound control. In this case the CodeBehind method names are provided to DataSource control on the aspx page and it uses those methods to get data from database.

in case of DataSource you get the data for example in a List or DataTable etc. and pass it to the DataBound control's DataSource property in the CodeBehind and call its DataBind() method after that.

I strongly recommend to used only one of these methods to bind your control and to fix the Columns problem you need to make sure that the data coming from database and binding either through DataSourceID method or DataSource, contains all the Columns expected by your DataBound control.

Good luck

_Amy · Answer 3 · 2013-09-25T22:52:00

The error is obvious. You can use "Only One" data source at a time. To resolve this error, do a quick check:
Go to design view of the page -> Find the control -> Remove DataSourceID property from it.
To know the details visit the link below:
MSDN : Data Source Controls Overview[^]

MSDN:
ASP.NET includes data source controls that allow you to work with different types of data sources such as a database, an XML file, or a middle-tier business object. Data source controls connect to and retrieve data from a data source and make it available for other controls to bind to, without requiring code. They can also support modifying data.

MSDN : BaseDataBoundControl.DataSourceID Property[^]

MSDN:
Gets or sets the ID of the control from which the data-bound control retrieves its list of data items.

--Amit

DataSource and DatasourceId

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0