Repeater and ListBOX

Question

0.00/5 (No votes)

See more:

LISTBOX[]

I have a listbox named Products and its attribute SelectionMode="Multiple"
i binded listbox with stored procedure
and listbox has the following....
Listbox.datatextfield=ProductName;
Listbox.dataValuefield=ProductID;

when i selected multiple items in the Listbox it will valuefield to a
stored procedure named GetProductdetailsbyid(ProductID)

it will get ProductName,ProductID,ProductRate,ProductUnit.

I have to store that to datatable and bind in an repeater Control..

Can Any One Try this and give a solution?

You can try other controls like datalist,gridview...

Thank YOu

Posted 9-Jun-11 21:29pm

sundarvil

Updated 9-Jun-11 21:34pm

v4

Add a Solution

Comments

RakeshMeena 10-Jun-11 3:33am

Why anybody else should try this? BAD..... You try and post the challenge that you face.

sundarvil 10-Jun-11 3:36am

I'm trying from past week itself.Still i did not able to find the solution. Tht's Y. I posted the question here

RakeshMeena 10-Jun-11 3:54am

I commented because you said "Can Any One Try this and give a solution?"... Anyways try my answer, that might help you, if not please post the issue. We'll try to resolve it.

1 solution

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)

RakeshMeena · Answer 1 · 2011-06-09T21:54:00

Solution 1

Try below steps:
1. You need to change you SP "GetProductdetailsbyid(ProductID)", since the listbox is multiselect and hence you should be able to pass multiple product id's to your SP.
2. Retrieve the recordset from your SP in datatable and bind it to the repeater control. This link will help you to start with.

Posted 9-Jun-11 21:54pm

RakeshMeena

Comments

sundarvil 10-Jun-11 4:53am

I'll try that today.... Can You try with the following Code.

protected void btnSelectItems_Click(object sender, EventArgs e)
{
int tot = Listbox1.Items.Count;
for (int x = 0; x < tot; x++)
{
if (Listbox1.Items[x].Selected.Equals(true))
{
Label1.Text = lstISRItems.Items[x].Value.ToString();
LoadSelectedItemsDetails(Label1.Text);
}
}
}
void LoadSelectedItems(ProductID)
{
DataTable dt= new DataTable();
BLLIssueSalesRoom objISR = new BLLIssueSalesRoom();//This will give link to the stored Procedure
dt = objISR.GetISRGetItems(Label1.Text);//this will call sp wit parameter
Repeater1.DataSource=dt;
Repeater1.DataBind();
}

Can u modify this?

yasar31 20-Dec-12 9:32am

what is mean lstISRItem ?