<div>
Thanks a lot David Sir. I will try suggested solution and will revert if any further assistance required.
</div>


<div>
David sir this my code but the suggested solution is not working, &nbsp;can u plsc modify my code. If I select one check box it works fine , for &nbsp;example if I select check box ( in checked list box) of US it filters &nbsp;data and shows only US data in rows, but if I select US then UK then it shows data of &nbsp;the last selected &nbsp;check box &nbsp;i.e &nbsp;UK. I want to see the data of &nbsp;both US and &nbsp;UK as both the check &nbsp;boxes &nbsp;are selected.<br />
<br />
&nbsp;Private Sub CheckedListBox1_ItemCheck(<wbr />sender As Object, e As ItemCheckEventArgs) Handles CheckedListBox1.ItemCheck<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim dbDataSet As New DataTable<br />
&nbsp; &nbsp; &nbsp; &nbsp; MySqlConn = New MySqlConnection<br />
&nbsp; &nbsp; &nbsp; &nbsp; MySqlConn.ConnectionString<wbr /> =<br />
&nbsp; &nbsp; &nbsp; &nbsp; &quot;server = localhost;userid=root;pass<wbr />word=5274;<wbr />database=c<wbr />ountry.dat<wbr />a&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim SDA As New MySqlDataAdapter<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim bsource As New BindingSource<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Try<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlConn.Open()<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dim Query As String<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Query = &quot;Select * from `country.data`.`trial` where &nbsp;`COUNTRY` in &nbsp;('&quot; &amp;&nbsp;CheckedListBox1.Text &amp;&nbsp;&quot;' )&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COMMAND = New MySqlCommand(Query, MySqlConn)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SDA.SelectCommand = COMMAND<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SDA.Fill(dbDataSet)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; bsource.DataSource = dbDataSet<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Me.DataGridView2.DataSourc<wbr />e = bsource<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SDA.Update(dbDataSet)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlConn.Close()<br />
&nbsp; &nbsp; &nbsp; &nbsp; Catch ex As MySqlException<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(ex.Message<wbr />)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Finally<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlConn.Dispose()<br />
&nbsp; &nbsp; &nbsp; &nbsp; End Try<br />
&nbsp; &nbsp; End Sub
</div>


<div>
<div class="content wysiwyg-content">
I have four columns in data grid view. one of the coloumn name is country which has 15 countries name. These names are available in the checked list box. I only want to see the data of only three countries in data grid view for which I have selected checked list box. Kindly tell me the query for using in select statement to filter only these countries details in data grid view.
</div>
</div>


I have four columns in data grid view. one of the coloumn name is country which has 15 countries name. These names are available in the checked list box. I only want to see the data of only three countries in data grid view for which I have selected checked list box. Kindly tell me the query for using in select statement to filter only these countries details in data grid view.

visual studio 2012 data grid view  checked list box usage

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,