Ask: how to extract the text content of the listBox control?

tcil9120

I want to call the text content in the listBox space in the database delete statement, but I don't know how to get the text content in this control, advice!
Such as textBox1.Text, similar to this text message

wenmy715

string str = listBox1.Items [i] .ToString ();

kalian2000

For example, take out the text content of the currently selected item:

if (this.listBox1.SelectedItem! = null)
            {
                // For example, take it out and put it in a TextBox
                this.textBox1.Text = this.listBox1.SelectedItem.ToString ();
            }

tcil9120

Sorry, I change a question, listBox2.Text seems to take out the text content, it may be that my database execution statement is wrong, my code
string strconn;
strconn = "data source = (local); initial catalog = student_pl; Integrated Security = SSPI;";
SqlConnection cn1 = new SqlConnection (strconn);
cn1.Open ();
string s = "delete from score where cname = '" + listBox2.Text + "'";
SqlCommand cmd1 = new SqlCommand ();
cmd1.Connection = cn1;
cmd1.CommandText = s;
cmd1.ExecuteNonQuery ();

After the execution, the record I want to delete is not deleted in the database. What is wrong, please advise

kalian2000

If you want to get the specified item:

            //E.g. Take out the first item
            this.textBox1 .Text = this.listBox1.Items [0] .ToString ();

kalian2000

Check if this record exists in the database?

kalian2000

TO: strconn = "data source = (local); initial catalog = student_pl; Integrated Security = SSPI;";


Or you better try with sa user ..

for example:

strconn = "server = .; database = student_pl; uid = sa; pwd = password";

Because I encountered this problem before when I used windows authentication to log in, you try it with sa user first.

tcil9120

I want to delete this record, my code doesn't know where the problem is

wenmy715

There seems to be nothing wrong with the code executed by the database ...
Pointing downstairs ...

kalian2000

You try as I said, try it with sa user ..