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

http://www.softwareforces.com/support/learning-center/step-by-step/rpt-inspector/changing-data-source-and-database-crystal-reports-dev-to-qa-to-production


Comments

Popular posts from this blog

javascript - jquery or ashx not working -

opencv - DataType<cv::detail::deriv_type>::depth what is it used for -

python 3.x - Mapping specific letters onto a list of words -