Error - Message = "Data source is an invalid type.

Hi Jignesh

  I am not getting tolist option

Thanks

Hello Ramco,

Have you check what it return type of this ?

rs.DoQuery("SELECT CardCode,CardName FROM OCRD");

You need to change here, just convert above one into list.

 grdBP.DataSource = rs.ToList();

Here's an example of how you might resolve this issue by converting the Recordset to a compatible data source before binding it to grdBP. You can use a DataTable as an intermediary data structure:

// Assuming grdBP is a DataGridView or a similar UI control

// Create a DataTable to hold the data from the Recordset
DataTable dataTable = new DataTable();
dataTable.Columns.Add("CardCode");
dataTable.Columns.Add("CardName");

// Move the data from the Recordset to the DataTable
if (!rs.EoF)
{
    while (!rs.EoF)
    {
        DataRow row = dataTable.NewRow();
        row["CardCode"] = rs.Fields.Item("CardCode").Value;
        row["CardName"] = rs.Fields.Item("CardName").Value;
        dataTable.Rows.Add(row);
        rs.MoveNext();
    }
}

// Set the DataTable as the DataSource for grdBP
grdBP.DataSource = dataTable;
grdBP.DataBind();

This code creates a DataTable, fills it with the data from the Recordset, and then sets the DataTable as the data source for grdBP.

Remember to replace DataGridView with the appropriate UI control that you're using in your application (e.g., GridView, DataGrid, etc.).

This approach ensures that the data source (DataTable) being assigned to the grid control is compatible with the data binding requirements.

The main issue you are facing is that your data source is basically a table and you are assigning a table to a set of rows. YOu need to initiate dataable variable to mapp the table as data source.

Thanks & Regards,
 

Problem

The error message "Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource" suggests that the DataSource property of the grdBP control is expecting a specific type, but the provided rs object does not match that type.

Cause

The cause of the issue is that the DataSource property of the grdBP control expects a data source that implements either the IListSource, IEnumerable, or IDataSource interface. However, the rs object in the code is of type SAPbobsCOM.Recordset, which does not implement any of these interfaces.

Solution

To resolve the issue, we need to convert the Recordset object to a compatible data source type before assigning it to the DataSource property of the grdBP control. One way to achieve this is by converting the Recordset to a DataTable object, which implements the IListSource interface.

Here's an updated version of the code that includes the necessary conversion:

SAPbobsCOM.SBObob obj = _oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoBridge);
SAPbobsCOM.Recordset rs = _oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
rs = obj.GetBPList(SAPbobsCOM.BoCardTypes.cCustomer);

int count = rs.RecordCount;
rs.DoQuery("SELECT CardCode,CardName FROM OCRD");

// Convert Recordset to DataTable
DataTable dt = new DataTable();
dt.Load(rs.GetFixedRecordset());

grdBP.DataSource = dt;
grdBP.DataBind();

In the updated code, we create a new DataTable object and load the data from the Recordset using the Load method. This converts the Recordset into a DataTable that can be assigned to the DataSource property of the grdBP control.

Make sure you should use the item it fills and for this u can load the data into a DataTable and then set the DataTable as the data source for your gridview control.

Refer below link, 

https://www.experts-exchange.com/questions/23196023/Error-Data-source-is-an-invalid-type-It-must-be-either-an-IListSource-IEnumerable-or-IDataSource.html

SAPbobsCOM.SBObob obj = _oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoBridge);
SAPbobsCOM.Recordset rs = _oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
rs = obj.GetBPList(SAPbobsCOM.BoCardTypes.cCustomer);

// Convert the Recordset to a DataTable
DataTable dataTable = new DataTable();
dataTable.Load(rs, LoadOption.OverwriteChanges);

// Now set the DataTable as the data source for the grid
grdBP.DataSource = dataTable;
grdBP.DataBind();

To resolve this issue, you need to convert the data from the Recordset to a suitable data structure that implements one of the required interfaces. One common approach is to load the data into a DataTable and then set the DataTable as the data source for your grid.

Hope this will help