Help with ListView Boxes

Question

1.00/5 (1 vote)

See more:

I have two listview boxes and their respective data is being stored in the database. What code I write in code event SelectIndexChanged. Ex: str = "select judgement from casetab WHERE partyname='" + listView1.Items + "'";

What should i change this "listView1.Items" to???

Please advise. Thank you, Nirmal

Posted 17-May-13 8:39am

Nirmal Gopalakrishnan

Add a Solution

Comments

Richard C Bishop 17-May-13 14:41pm

I would use:

listView1.SelectedValue.ToString()

ZurdoDev 17-May-13 14:42pm

You should post as solution.

[no name] 17-May-13 14:42pm

Hi Rich,
Sorry, I am not getting Selected Value in the Intellisense

Richard C Bishop 17-May-13 14:46pm

Post the code you have for the ListView. ListView has a SelectedValue I assure you.

[no name] 17-May-13 14:45pm

private void listView1_SelectedIndexChanged(object sender, EventArgs e)
{
listView2.Items.Clear();

OleDbConnection cs = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\lms\ssc.mdb;");
string str;
//OleDbCommand cmd = new OleDbCommand("SELECT * FROM casetab", cs);

listView2.View = View.Details;
// listView2.GridLines = true;
//listView2.BackColor = Color.Aqua;
// listView2.ForeColor = Color.Blue;

cs.Open();
str = "select judgement from casetab WHERE partyname='" + listView1.SelectedValue.ToString()+ "'";

OleDbCommand cmd;
cmd = new OleDbCommand(str, cs);

OleDbDataAdapter da;
da = new OleDbDataAdapter(cmd);

DataSet ds;

ds = new DataSet();
da.Fill(ds, "casetab");
cs.Close();

DataTable dt;
dt = ds.Tables["casetab"];

int i;
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
listView2.Items.Add(dt.Rows[i].ItemArray[0].ToString());
// listView2.Items[i].SubItems.Add(dt.Rows[i].ItemArray[1].ToString());

}
}

Richard C Bishop 17-May-13 14:47pm

Is this not working? Any errors?

[no name] 17-May-13 14:48pm

I manually added SelectedValue. This is the error message:Error 36 'System.Windows.Forms.ListView' does not contain a definition for 'SelectedValue' and no extension method 'SelectedValue' accepting a first argument of type 'System.Windows.Forms.ListView' could be found (are you missing a using directive or an assembly reference?) D:\LMS\LMS\LMS\frmMain.cs 452 81 LMS

Richard C Bishop 17-May-13 14:49pm

Well, you did not specify "Forms" in your question or tags. Use SelectedItems.ToString().

[no name] 17-May-13 14:51pm

if use SelectedItems, nothing is happening :(
str = "select judgement from casetab WHERE partyname='" + listView1.SelectedItems.ToString()+ "'";

Richard C Bishop 17-May-13 14:54pm

Any errors though?

[no name] 17-May-13 14:58pm

Nope, no errors.

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)

Richard C Bishop · Answer 1 · 2013-05-17T08:53:00

Solution 1

Since this is a Windows Forms application you can use:

listView1.SelectedItems.ToString()

SAK might take issue with this, but I am not exactly sure how to use ENUMS yet and definitely am not capable of telling others to.

Posted 17-May-13 8:53am

Richard C Bishop

Comments

[no name] 17-May-13 14:56pm

Hmm.. Okie. If you could atleast let me know how to increase the height of the text displayed in the listview. I have a column called judgement and text in it is huge. I am able to only view only one line in the listview.

Would you be able to assist.

--
NG

Richard C Bishop 17-May-13 15:03pm

Add a try catch to your application and debug it in order to find out where it stops working. As far as formating the text, I am not sure on that. Research it, as that is what I would have to do.