how to convert the recordset to datatable

[Former Member]

i given a sample code here...

tempcoa = ((SAPbobsCOM.BusinessPartners)(tempcomp.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oBusinessPartners)));

temprecset = ((SAPbobsCOM.Recordset)(tempcomp.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)));

temprecset.DoQuery("select CardCode,CardName from OCRD where CardType ='S'");

tempcoa.Browser.Recordset = temprecset;

this tempreset is a recordset ..

i want to convert this to be datatable?

[Nussi · Accepted solution]

Hi,

look at this [Link|;

there you see how to load a matrix with a datatable.

it's no big deal - place your recordset in .DoQuery

and bind the columns

lg David

[Former Member · Accepted solution]

Hi, David Nussböck

we solved through XML.

Reagds,

Sampath Kumar Devunuri.

[Former Member]

Hi,

Try this..

OForm= sbo_application.Forms.Item("FormUid")

OForm.DataSources.DataTables.Add("Data")

OForm.DataSources.DataTables.Item("Data").ExecuteQuery("select CardCode,CardName from OCRD where CardType ='S'")

if you want to bind the values with matrix means, then

OMatrix=OForm.Items.Item("MatrixUid").Specific

OMatrix.Columns.Item("colid").DataBind.Bind("Data", "CardCode")

OMatrix.Columns.Item("Colid").DataBind.Bind("Data", "CardName")

OMatrix.Clear()

OMatrix.LoadFromDataSource()

OMatrix.AutoResizeColumns()

Regards,

Ganesh k