I have an eval version of the latest version of Aspose.Grid (version 2.0). When I perform a Databind to a SQL Query it appears to bind (has the correct number of rows in the grid) but no data is displayed.
ssql is a properly formated sql query statement...
sqlcommand1.CommandText = ssql
sqlcommand1.CommandType = System.Data.CommandType.Text
Dim ps = New DataSet
Dim sadaptor = New SqlClient.SqlDataAdapter(sqlcommand1)
Dim sheet As WebWorksheet = GridWeb1.WebWorksheets(0)
sheet.EnableCreateBindColumnHeader = True
sheet.BindStartRow = 2
sheet.Cells.Merge(0, 0, 2, 50)
sheet.DataSource = ps
Secondly, I want to size the grid to a portion of the form, but using the
GridWeb1.Height = New Unit(60, UnitType.Percentage)
GridWeb1.Width = New Unit(75, UnitType.Percentage)
has no impact on its size. I have tried using other UnitTypes as well with no luck.
Thank you for your help.