Casting the number of records 1

[peekay]

I have the number of records from a executescalar query. Now I wish to resize my datagrid.height to 30 times this number, but I am unable to cast the number of rows * 30 to height in pixels. It says the type integer cannot be converted to system.web.ui.webcontrols.unit
Can someone please help me.
Thanks

PK Odendaal

http://www.odendaal.com

 

[adamroof]

Here ya go, dont know why you want to do that, but...

  Dim ds As New DataSet()
  myCommand.Fill(ds)

  MasterGrid.DataSource = ds
  MasterGrid.DataBind()
     Dim intMultiplier As Integer = ds.Tables(0).Rows.Count 
     Dim intCalc As Integer = intMultiplier * 30
  MasterGrid.Height = unit.pixel(intCalc)

 

[adamroof]

Or just...

Dim intCalc As Integer = ds.Tables(0).Rows.Count * 30
dg.height = unit.pixel(intCalc)