c#水晶报表-数据库问题(答案满意立刻结贴!)
用visual2005开发水晶报表时,总是弹出 数据库登录对话框。
这里数据库用的是Oracle,远程访问服务器的。
String strConn = "Data Source=stddb_150;Persist Security Info=True;User ID=hexing;password=hexing;Unicode=True";
String strSql = "select distinct a.jcrxm,b.ssdw,a.szbz,a.jcsj,b.ryxm,c.wxy,b.cfjg " +
" from s_gbxjhbb a,s_wzry b,d_wxy c,s_swqk d where a.id=d.xjhbbh and c.id=d.swbh";
OracleConnection orConn = new OracleConnection(strConn);
orConn.Open();
OracleCommand orCmd = orConn.CreateCommand();
OracleDataAdapter orDataAdapter = new OracleDataAdapter();
DataSet ds = new DataSet();
orCmd.CommandType = CommandType.Text;
orCmd.CommandText = strSql;
orDataAdapter.SelectCommand = orCmd;
orDataAdapter.Fill(ds);
orConn.Close();
crvGzmpgtjReport crvReport = new crvGzmpgtjReport();
//DataTable dt = ds.Tables["Table"];
//crvReport.SetDataSource(ds);
crystalReportViewer1.ReportSource=crvReport;
这段是Load事件的代码,请看这怎么改了?
答案满意立刻结贴!