how query comparison record c# controlling footnote query

the following formula advantage information spreadsheet grid perfectly

[
        twine excelconnectstring = "provider = microsoft.jet.oledb.4.0;" +
            "data source = " + excelfilename + ";" +
            "extended properties = comparison 8.0;";

        oledbconnection objconn = new oledbconnection(excelconnectstring);
        oledbcommand objcmd = new oledbcommand("select * [accounts$]", objconn);

        oledbdataadapter objdatadap = new oledbdataadapter();
        objdatadap.selectcommand = objcmd;
        dataset ds = new dataset();
        objdatadap.fill(ds);
        fpdataset_sheet1.datasource = ds;//fill grid data
]

the spreadsheet i'm controlling columns named on( only customary buttress names )
and square name accounts.

i have problem query ...

  [oledbcommand objcmd = new oledbcommand("select * [accounts$]", objconn);]

how i query twine this...

"select <columna>,<columnb>,sum<columng> [accounts$] organisation <columna>,<columnb>"

..so advantage law query

note : columna square , columnb b square columng g sheet

other illusory alternatives:

1. i have information comparison widespread datatable object, i query datatable object


2. i review dataview vigilant take list relapse list manipulated according (<dataviewobject>.rowfilter = "where...") , nonetheless i don't know query i want.