Using the If Condition

bex · June 29th, 2009, 09:19 AM

Hi There,
I Need help with this

I have this code that populates a DataGrid in .Net 3.5 Win Forms works fine,
i need to add an if statment that if cmd returns >1 records Then windows2.show.

The idea is the if query returns more than 1 record a popup asks you wich one do you want to show, than you click the one you need and the datagrid populates with that record..

Code:

 
Dim cmd As SqlCommand = cnn.CreateCommand
cmd.CommandType = CommandType.Text
cmd.CommandText = "SELECT SLP05.CNAM05, SLP05.CUSN05, SLP05.CAD205, SimDefault.SimNet, SimDefault.Cost, SimDefault.Commission FROM SimDefault CROSS JOIN SLP05 Where (SLP05.CNAM05 Like '" & txtName.Text & "%')"Dim da As SqlDataAdapter = New SqlDataAdapter
da.SelectCommand = cmd
Dim ds As DataSet = New DataSet
da.Fill(ds, "CNAM05")
DataGridViewSearch.DataSource = ds
DataGridViewSearch.DataMember = "CNAM05"

alliancejhall · June 29th, 2009, 07:34 PM

could you just count the rows of the gridview?

Code:

If GridViewSearch.Rows.Count > 1 Then
  Windows2.Show()
End If

bex · June 30th, 2009, 02:34 AM

Thanks 4 the reply, i could count the rows but the rows returned are not of a fixed number.

Most of the time the grid populates 13 rows of 1 customer with deferent field of sim , cost...
2 customers can have the same name but not same address, it would be ideal to check 4 postcode.
Something like Name Bill has 2 post codes than you check the 2 post codes are different than pop up the Windows2.Show()