Friends:

I have a question.. now..in my form I have 4 checkboxes and I have a click button..the idea is when any one or 2 or 3 or all 4 checkboxes are checked, a SQL statement should be executed and the results should be displayed in a datagridview.

now..i have been writing the code for the checkedstate=true/false in the button_clicked code..do I have to write any code inside the checkbox1_checkedchanged and similarly for the other check boxes?

Please let me know..

thanks

kavitha.

my code is as follows

Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click

Dim con As OleDbConnection = New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\Documents and Settings\bashkark\Desktop\Copy of USERS.mdb")

Dim cmd1 As New OleDbCommand

con.Open()

If (CheckBox1.Checked = True) And (CheckBox1.Checked = True) And (CheckBox3.Checked = True) And (CheckBox4.Checked = True) Then

cmd1 = New OleDbCommand("select * from table1 where MECH='X' and MACH='X' AND UGSTRUCTURES='X' AND UGPCBXCHANGE='X'")

Dim da As OleDbDataAdapter = New OleDbDataAdapter(cmd1)

Try
Dim ds As DataSet = New DataSet()

ds.Tables.Add("table1")

da.Fill(ds, "table1")

DataGridView1.DataSource = ds.Tables("table1").DefaultView

Finally

con.Close()

cmd1 = Nothing

da.Dispose()

con.Dispose()


End Try

End If

End Sub

End class

This article has been dead for over six months. Start a new discussion instead.