Assigning a DataTable to SqlDataSource

Question

I’ve got a custom Data access layer in my ASP.NET project. It goes to the db and retrieves all data required and returns it as DataTable objects. I want to bind one of the DataTables to DevExpress ComboBox control:

var productsDal = DalProviderFactory.Instance.GetProductsDal();
cbProducts.DataSource = productsDal.GetAllProductNames(); //--> One-column DataTable object is returned here.
cbProducts.DataMember = "ProductName"; //--> Specifying name of the column.
cbProducts.DataBind();

This doesn’t work; it definitely binds something but doesn’t display it properly:

enter image description here

Ok. I found out that the ComboBox actually accepts SqlDataSource object as its DataSource. So I’ce tried to configure one:

<asp:SqlDataSource ID="dsProducts" runat="server" />

Now instead of having it connecting to the db itself, I want to use my DAL and somehow assign the datatable to the SqlDataSource. Is there any way of doing this?

Thanks in advance.

amartynov · Accepted Answer · 2011-09-20 13:10:34Z

1

Bashir,

use the TextField property of ASPxComboBox:

<dx:ASPxComboBox runat="server" TextField="HERE" />

answered Sep 20, 2011 at 13:10

amartynov

4,2152 gold badges34 silver badges36 bronze badges

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

1 Comment

Bashir Magomedov Over a year ago

I always wonder why DevExpress developers change standard names to something completely misleading :(. It is like this in WinForms controls (one particular thing that drives me crazy – when you need to use Hidden instead of Visible for visual controls) and now I see exactly the same stuff in WebForms. :( Anyway thank you very much! Spasibo! :)

Sandeep G B · Accepted Answer · 2011-09-20 11:47:51Z

0

Setting the DisplayMember should fix the problem.

answered Sep 20, 2011 at 11:47

Sandeep G B

4,0155 gold badges29 silver badges44 bronze badges

1 Comment

Bashir Magomedov Over a year ago

There is no DisplayMember property in ASPxComboBox class

Collectives™ on Stack Overflow

Assigning a DataTable to SqlDataSource

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related