How to set a Listbox selected items from database?

Question

0.00/5 (No votes)

See more:

I want to design an edit page in a web application. I have a listbox in my form which has selected items stored in my database. Now I want to have them selected on page_load in my listbox. I tried item.selected = true, but it doesn't work. and I have no more idea how to do this

Posted 12-Oct-10 1:33am

Maziyarkh

Add a Solution

Comments

Ajith80301 12-Oct-10 7:38am

Can you tell how did you save those selected items in the database?? Then it would be easier to suggest a solution..

Brij 12-Oct-10 9:30am

Can you post your code? It will help us to answer better

Maziyarkh 13-Oct-10 12:50pm

I stored the values in a database, but I used several classes and tables and ... so it just complicates the situation and I have to post the whole project. But I understood something, if the ListBox is static with certain items, this code will select all fields on page load:

foreach (ListItem index in StaticListBox.Items)
{
index.Selected = true;
}
which is written in page_load, but if the listbox is dynamic (which is mine), the same code does'nt work.
so the first step and first question is how to select all items of a listbox?

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)

Mohd Wasif · Answer 1 · 2010-10-12T03:03:00

create table employee(
ID int,
name nvarchar (10),
salary int,
start_date datetime,
city nvarchar (10),
region char (1))
Let us suppose this is our table .I am giving the code that you need to use.
make a method as in the code behind of page.
void bindlist()
{
SqlCommand cmd = new SqlCommand("select * from employee", con);
con.Open();
SqlDataReader dtr = cmd.ExecuteReader();
ListBox1.DataSource = dtr;
ListBox1.DataTextField = "name";
ListBox1.DataValueField = "ID";
ListBox1.DataBind();
con.Close();

}
and call it in as
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
bindlist();

}

m@dhu · Answer 2 · 2010-10-12T03:31:00

Solution 2

Listbox1.SelectedValue=//value from db

Posted 12-Oct-10 3:31am

m@dhu

Maziyarkh · Answer 3 · 2010-10-13T00:25:00

thanks for your response, but it's not the solution. lets make my quesyion easier. Noe I just want to select all items in a ListBox which gets its Items from a database.
if the ListBox is static with certain items, this code will select all fields on page load:
<pre lang="cs">foreach (ListItem index in StaticListBox.Items)
{
index.Selected = true;
}</pre>
which is written in page_load, but if the listbox is dynamic (which is mine), the same code does'nt work. I can bind my ListBox to a database, but I can't select them with code.

How to set a Listbox selected items from database?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0