c# - I have created a .rdlc-Report under VS 2012 using the report i want to assign data source and report name at run time -


i have many reports project , have report viewer , want open reports in viewer, viewer data source assigned @ run time , report name also

dataset ds = new dataset();  datatable dt = new datatable();                using (sqlcommand cmd = new sqlcommand("r_purchase_order_detail", parent.v_connection)) {     cmd.commandtype = commandtype.storedprocedure;     cmd.parameters.add(new sqlparameter("start_code", sqldbtype.varchar)).value = "0000000000";     cmd.parameters.add(new sqlparameter("end_code", sqldbtype.varchar)).value = "9999999999";     cmd.executenonquery();     sqldataadapter da = new sqldataadapter(cmd);     da.fill(ds); } reportviewer1.processingmode = processingmode.local; reportviewer1.localreport.reportpath = @"e:\businessbook\businessbook\businessbook\zreports\purchase\r_purchase_order_detail.rdlc";  reportdatasource datasource = new reportdatasource("r_purchase_order_detail", ds.tables[0]);  this.reportviewer1.localreport.datasources.clear(); reportviewer1.localreport.datasources.add(datasource); reportviewer1.localreport.refresh(); reportviewer1.refreshreport(); 


Comments

Popular posts from this blog

python - Operations inside variables -

Generic Map Parameter java -

arrays - What causes a java.lang.ArrayIndexOutOfBoundsException and how do I prevent it? -