-
grid question
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