select item from listbox and pass it as query to other form

Question

I have a winforms app in C# in with a user is prompted to select from a range of items, the items are displayed in a listview with the checkboxes set to true. After the user selects one item i want the description and a value from an SQL database to be displayed in another form, in 2 textboxes. Is there a way to accomplish this? I think it would be something like:

  private void button1_Click(object sender, EventArgs e)
    {
        If(listView1.SelectedItems = ??); 
        {
            "select[descri] + '  ' + [compo] from vidros" 
             pass it to form "build" in textbox "desc2"           
            "select valu from vidros" 
             pass it to form "build" in textbox "tt"
             this.close();
        }
        else
        {
            MessageBox.Show("Please select an item!", "Warning!");
        }
    }

Community · Accepted Answer · 2017-05-23 12:17:06Z

1

it is possible. And all the answers are here on StackOverflow:

After the user selects one item

Get single listView SelectedItem

"select[descri] + ' ' + [compo] from vidros"

How to retrieve data from a SQL Server database in C#?

pass it to form "build" in textbox "desc2"

Send values from one form to another form

I wish you success constructing all this information into working code :)

edited May 23, 2017 at 12:17

CommunityBot

11 silver badge

answered Feb 22, 2017 at 13:45

Mong Zhu

23.8k10 gold badges47 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

septaug Over a year ago

Thanks, ill surely try :)

Collectives™ on Stack Overflow

select item from listbox and pass it as query to other form

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related