Fill Grid

[Former Member]

How to fill Grid using Recordset?

Please help

[Former Member]

Use this,

oGr.DataTable.ExecuteQuery("SELECT * FROM OHEM")

Vasu Natari.

[Nussi]

Hi,

here's a c# sample

oForm.DataSources.DataTables.Add("MyDataTable");
 
((SAPbouiCOM.Grid)(oForm.Items.Item("grid").Specific)).DataTable = oForm.DataSources.DataTables.Item("MyDataTable");
 
oForm.DataSources.DataTables.Item(0).ExecuteQuery("SELECT Field FROM [dbname].dbo.TABLE");
 
((SAPbouiCOM.Grid)(oForm.Items.Item("grid").Specific)).CollapseLevel = 1;
((SAPbouiCOM.Grid)(oForm.Items.Item("grid").Specific)).AutoResizeColumns();

just edit the SELECT and correct the "grid" name

lg David