Code:
Public Sub DropDownType_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownType.SelectedIndexChanged

            Dim CON As OdbcConnection
            Dim CMD As OdbcCommand
            Dim DTR As OdbcDataReader


            CON = New OdbcConnection("DSN=STOCK")
            CON.Open()

            'response.Write(dropdowntype.

            CMD = New OdbcCommand("SELECT * FROM producten where pro_type=?", CON)
            CMD.Parameters.Add("@type", DropDownType.SelectedItem.Value)

            GridProducten.DataSource = CMD.ExecuteReader
            GridProducten.DataBind()
            GridProducten.CellPadding = 20
            CON.Close()


    End Sub
after executing this code the height of my rows is a lot more, maybe because the grid has to show less records now, is there an option to fixate the formatting?

If i could fixate the number of rows shown (independent from the number of records shown), i would like that too!

thanx