retrive multiple selected items on gridview selected index changed event

Question

0.00/5 (No votes)

See more:

i have multiple selected value from checklistbox but my code return only last selected value ...

SQL

i hv 2 tables.
1 student table and 1 subject table. i want subject value from sub table.
but my problm is that when i select it from grid view it fills only last selected value....from sub table.....and not all values...
i have done all the things dynamically....

code is:

C#

String qr = "select * from stusub where StuID='" + gv1.SelectedRow.Cells[1].Text + "' ";
SqlCommand cm = new SqlCommand(qr, conn);
conn.Open();
SqlDataReader dr1 = cm.ExecuteReader();

DataTable dt1 = new DataTable();
dt1.Load(dr1);
for (int i = 0; i < dt1.Rows.Count; i++)
{
  lbSubject.SelectedValue = Convert.ToString(dt1.Rows[i]["SubID"]);
}
conn.Close();

Posted 6-Sep-12 21:09pm

Member 9332883

Updated 6-Sep-12 21:30pm

v3

Add a Solution

2 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)

Rickin Kane · Answer 1 · 2012-09-06T21:16:00

Solution 1

Can you explain , what exactly u mean , do u have check box n each row of gridview or multiple check box on a single row

if you one check box on every row of Gridview and then make it as template column

Then using Grdivew Rowcommand , you can do the for each loop.

Posted 6-Sep-12 21:16pm

Rickin Kane

Comments

_Amy 7-Sep-12 3:22am

You should not ask your doubts here in the solution box.

Member 9332883 7-Sep-12 3:23am

see.
i hv 2 tables.
1 student table and 1 subject table. i want subject value from sub table.
but my problm is that when i select it from grid view it fills only last selected value....from sub table.....and not all values...
i have done all the things dynamically....i need it urgently...plz make it fast....

_Amy · Answer 2 · 2012-09-06T21:20:00

Hi,
You should follow these steps:

Quote:
1. Fetch all the selected row from your gridview.
2. Store it in a string separated with comma. Like (2, 3, 4, 5)
3. Now use IN operator in your sql query. Like:
"SELECT * FROM stusub WHERE StuID IN '" + GridviewSelectedRows + "' ";
Here GridviewSelectedRows is the the string which you are framing with comma separation.
4. Now get the recordset from database.

Follow the steps and try your best.
All the best.
--Amit