Crystal Report in c# window application -
here code set data on crystal report data not comin in data set same time dataset fill datagridview. please me. in advance
private void button1_click(object sender, eventargs e) { reportdocument crystalrpt = new reportdocument(); crystalrpt.load(@"e:\c#\date_day\date_day\cr1.rpt"); rst_prntdataset prnt = getdata("select * dbo.empl_trn"); crystalrpt.setdatasource(prnt); crv1.reportsource = crystalrpt; crv1.refresh(); } private rst_prntdataset getdata(string qry) { string cs = configurationmanager.connectionstrings["rst"].connectionstring; sqlcommand cmd = new sqlcommand(qry); using (sqlconnection con = new sqlconnection(cs)) { using (sqldataadapter da = new sqldataadapter()) { cmd.connection = con; da.selectcommand = cmd; using (rst_prntdataset prnt = new rst_prntdataset()) { da.fill(prnt, "tbl1"); return prnt; } } } }
are change db object after creating report i.e. report upto date database.
if yes, please check in result in design mode passing value (just f5 view result).
if no, simple go "database" menu -> "update database" , follow step below link
Comments
Post a Comment