>Hi
>I am trying to create a Grid for displaying the recorset but I am getting an error.(Runtime exception)at Grid.Rows
>I am sending the code please tell where I have gone wrong
>
>
>set con=s e r v e r.CreateObject("ADODB.Connection")
>set rs=s e r v e r.CreateObject("ADODB.Recordset")
>con.Open cnstr
>msql="Select * from Customer_Mst"
>rs.Open msql,con
>SET Grid=S E R V E R.CreateObject("MSHierarchicalFlexGridLib.MSHFlexGrid.6")
>Grid.Rows=5
>Grid.Cols=5
>while not rs.EOF
> Grid.TextMatrix(0,0)=rs.Fields("Cust_Code")
> rs.MoveNext
>wend
The way you're coding this, you create the grid on the server. Not very usefull for your users.
The way to do it is to add a Object tag that points to a cab file (containing the grid) on your server. IE will download and install the grid locally. In your ASP code, you can program script that will run locally to populate the grid or use RDS (Remote Data Services) to connect to your data.
If you don't need the complexity of a grid, just output your data in an HTML table.