水晶报表动态连接数据源问题

Question

ISmDataAccess smDa = (ISmDataAccess)Application["SmDataAccess"];
  string constr=smDa.Connection.ConnectionString ;
          OracleConnection con = new OracleConnection(constr);
con.Open();
string sql="select * from JYCQ.V_HOUSEFCZS where PROINS_ID=1547";
             OracleDataAdapter ordataAdp = new OracleDataAdapter(sql,con);
             DatasetAllZS ds = new DatasetAllZS();    
 ordataAdp.Fill(ds,"V_HOUSEFCZS"); 
 this.rdSYQZ.SetDataSource(ordataAdp);
             ((CrystalDecisions.Web.CrystalReportViewer)this.utab.FindControl("crvSYQZ")).ReportSource =  this.rdSYQZ;
 ((CrystalDecisions.Web.CrystalReportViewer)this.utab.FindControl("crvSYQZ")).DataBind();
代码在执行到this.rdSYQZ.SetDataSource(ordataAdp); 发生了错误,提示说数据源不正确,
不知道是什么原因

Answer 1

感觉你写的有些乱.参照下这个贴子
http://community.csdn.net/Expert/topic/4791/4791326.xml?temp=.2459833

Answer 2

this.rdSYQZ.SetDataSource(ordataAdp);改为 this.rdSYQZ.SetDataSource(ds);