Additional information: Complex DataBinding accepts as a data source either an IList or an IListSource

See more:

C#

MS-Excel

ListBox

hi iam trying to select sum of total in excel sheets and add it into a list box each one of them in a new line

here is my code

private void btn_update_Click(object sender, EventArgs e)
    {

        for (int i = list_sheetnames.Items.Count -1; i >= 0; i--)
        {


            string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + textBox_filename.Text + ";Extended Properties='Excel 12.0 XML;HDR=YES;';";

            string selectCmd = "Select SUM(Total) As Total_SUM From [" + list_sheetnames.Items[i] + "$]";

            using(OleDbConnection excelConn = new OleDbConnection(connString))
            {
                excelConn.Open(); 
                OleDbCommand command = new OleDbCommand(selectCmd, excelConn);
                OleDbDataAdapter da = new OleDbDataAdapter(command);

                DataTable sheetInfo = new DataTable();
                da.Fill(sheetInfo);

                //Do something with the data.
                //list_total.Items.Add(sheetInfo);
                list_total.DataSource = da.ToString();
            }
}

and i got this error

could you please help me to find the solution

i change my code into this

List<string> lst = new List<string>();
                    foreach (DataRow r in sheetInfo.Rows)
                    {
                        string sheettotal = (string)r["Total_SUM"].ToString();
                        lst.Add(sheettotal);
                        
                    }
                    list_total.DataSource = lst;

and its working but only add the last total in the list box