Prepare a data management programme with visual basic

Assignment Help Visual Basic Programming

Reference no: EM131161465

You need to prepare a data management programme with visual basic 2012 as front end and MySql as back end.

I want to filter data grid view table with List box (multiple selected) .

When I select one item it works fine and when I select multiple items in the List box. I am able to get all the items of a column in the list box by following code

Query = "Select * from `rrrr.data`.`trial` "
COMMAND = New MySqlCommand(Query, MySqlConn)
READER = COMMAND.ExecuteReader
While READER.Read
Dim sCountry = READER.GetString("COUNTRY")
ListBox1.Items.Add(sCountry)
End While

But for filtering data when I use below query it does not work ( for multiple selected or more than one item ) It does not work Query which I use is-
Query = "Select * from `rrrr.data`.`trial` Where `COUNTRY`in (''" & ListBox1.SelectedItem& "'' )"

Reference no: EM131161465

Questions Cloud

Amount of initial information : How much searching a consumer does will depend on the strength of the drive, the amount of initial information, the ease of obtaining more information, the value placed on additional information, and the satisfaction one gets from searching.

Think about the compensation and benefit options : Think about the compensation and benefit options. Develop a list of up to three potential benefits that could be offered to employees. Be creatvie with the list. Things such as pet insurance and trips to China for inexpensive plastic surgery coudl be..

Discuss where the company is growing the most : In the cases where the companies has a stronger global footprint (i.e. Ford), discuss where the company is growing the most, what new markets should they consider entering and why, and what markets would you recommend they get out of (if any), and..

What does it mean to be a critical consumer : 1) What does it mean to be a critical consumer? How do advertisers try to get you away from this? 2) How does ethnocentrism get in the way of critical thinking?

Prepare a data management programme with visual basic : You need to prepare a data management programme with visual basic 2012 as front end and MySql as back end.

Reducing health care costs and optimizing revenue streams : Managed care organizations have historically focused on reducing health care costs and optimizing revenue streams. Identifies two initiatives utilized by managed care organization to reduce health care costs and optimize revenue streams.

Write paper on child abuse reporting issues and resources : Describe what could result when the following occur: Families or individuals will not agree to receiving help and The child is in further danger due to reporting an incident.

Overcome online retailers advantages : 1. What kind of price strategy are Target and Best Buy using to overcome online retailers' advantages?

What should prospective buyers of commercial property : Discuss the precautions necessary for the safe handling of a hazardous waste that exhibits the characteristics of ignitibility and toxicity. What should prospective buyers of commercial property do in order to protect themselves from liability unde..

User Account

All Pages