Change ListBox datasource dynamically

Question

0.00/5 (No votes)

See more:

Hallo,

I want to change the datasource of a listbox dynamically, i.e. modify the select statement in the SQLDatasource, depending on which button is clicked. How can I do that? This is how my Listbox looks like:

XML

<asp:ListBox ID="lst_objects" runat="server" DataSourceID="SqlDataSource1"
                    DataTextField="field1" DataValueField="field2"></asp:ListBox>

Posted 12-Oct-11 22:54pm

chris085

Add a Solution

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)

Muralikrishna8811 · Answer 1 · 2011-10-12T23:17:00

Hi,

you can change your sqldatasource on button click event

C#

SqlDataSource1.SelectCommand = "";
     ListBox.Datasource = SqlDataSource1;
     ListBox.DataTextField = "displayfieldid";
     ListBox.DataValueField = "valuefieldid";
     ListBox.DataBind();

By using this code you can change your select command query also

All the Best

Kishore Jangid · Answer 2 · 2011-10-12T22:59:00

Solution 1

C#

lst_objects.DataSourceID=sqlDataSource1;
lst_objectsDataTextField="field1";
lst_objects.DataValueField="field2";
lst_objects.DataBind()  //Very Important

Posted 12-Oct-11 22:59pm

Kishore Jangid

koolprasad2003 · Answer 3 · 2011-10-12T23:09:00

Solution 2

In your example you have given datasourceID, dataTextfield in htmlSource but it's static.
do the same thing in code behind to make it dynamic, here is code. call it on button click.

C#

lstBox.DataSourceID=sqlDataSource1;
lstBox.DataTextField="fld1";
lstBox.DataValueField="fld2";
lstBox.DataBind();

Posted 12-Oct-11 23:09pm

koolprasad2003

Comments

chris085 13-Oct-11 5:18am

So you mean to remove the code in the aspx file and to add this to the code behind? or what should be kept in the aspx?