Posted 28 September 2017, 11:07 am EST
[activereports_archive]private void ActiveReport_ReportStart(object sender, EventArgs e)
{
ActiveReport rpt = new ActiveReport();
rpt.AddScriptReference(@"C:\Oracle12c\product\12.2.0\client_1\odp.net\bin\4\Oracle.DataAccess.dll");
// Oracle Namespaces
// rpt.AddScriptReference(“Oracle.DataAccess.Client”);
// rpt.AddScriptReference(“Oracle.DataAccess.Types”);
string oraDB = "Data Source=XE;User;Password=hr;";
OracleConnection con = new OracleConnection(oraDB);
con.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText = "select department_id, department_name from DEPARTMENTS";
OracleDataReader reader = cmd.ExecuteReader();
}
private void ActiveReport_DataInitialize(object sender, EventArgs e)
{
rpt.Fields.Add(“department_id”);
rpt.Fields.Add(“STATEPROJECTNUM”);
rpt.Fields.Add(“VENDORNAME”);
}
public bool ActiveReport_FetchData(bool eof)
{
try
{
reader.Read();
rpt.Fields[“department_id”].Value = reader[“department_id”].ToString();
rpt.Fields[“department_name”].Value = reader[“department_name”].ToString();
eof = false;
}
catch
{
eof = true;
}
return eof;
}
[/activereports_archive]