Getting data in c# using odbc connection -


i tried data in crystal report using odbc tally.erp9.

con.open(); odbccommand cmd=new odbccommand("select ledger.`$_name`, ledger.`$_closingbalance`, ledger.`$_openingbalance` ashtamunicipalcouncil.tallyuser.ledger ledger", con); cmd.executenonquery(); dataset1 ds1 = new dataset1(); odbcdataadapter da = new odbcdataadapter(cmd); da.fill(ds1.datatable1); crystalreport1 crv = new crystalreport1(); crv.setdatasource(ds1); crystalreportviewer1.reportsource = crv; crystalreportviewer1.refreshreport(); con.close(); 

the above code gives me result gives blank records , crystal report viewer shows me no of pages contain.


Comments

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

customize file_field button ruby on rails -

SoapUI on windows 10 - high DPI/4K scaling issue -