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
Post a Comment