use DataView when popuate a Gridview via SQLDataSource

Question

I' workingon an ASP.NET project and in order to populate a GridView with datat from a SQL Server Database' table I use SQLDataSource and everythings goes just fine.

But now I need to add the option to sort the columns of the gridview(ASC-Desc), for that purpose I want to use a DataView and got the next code

DataView dv = new DataView();
 dv = (DataView)Ejemplo.Select(DataSourceSelectArguments.Empty);
 dv.Sort = "Departmento Desc";
 GridView1.DataSource = dv;

but got this error message:

Both DataSource and DataSourceID are defined on 'GridView1'.  Remove one definition.

Could you please help me and tell what am I doing wrong?

See datasource vs datasource Id. Looks like you want to use a datasource. Remove the DataSourceId that you have probably set declaratively for your GridView (look at your .ascx/.aspx file) — Tung
– Tung, Commented Oct 23, 2015 at 0:00
@Tung I just did but now the gridView doesn't appears at all — El Neto
– El Neto, Commented Oct 23, 2015 at 0:27
Did you call Gridview1.DataBind() after you assigned the datasource? — Tung
– Tung, Commented Oct 23, 2015 at 0:30
@Tung thanks, your answer helped me out...where should I mark your anserw as the one that fixed my problem? in the arrow up? — El Neto
– El Neto, Commented Oct 23, 2015 at 2:41

Community · Accepted Answer · 2017-05-23 10:27:06Z

0

The GridView can be bound to a data source by either setting a datasourceId or by assigning a datasource object to the DataSource property, but not both. This is explained here.

To resolve the issue, remove the datasourceId from your .aspx/.ascx file.

@ElNeto, cheers

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered Oct 23, 2015 at 4:46

Tung

5,4641 gold badge38 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

use DataView when popuate a Gridview via SQLDataSource

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related