Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.
This is the exception i am getting when i executing my crystal report form and i am using push method to get data items. Plz help me
this very urgent.
the code i implemented is:
DataSet1 ds1 = new DataSet1();
DataTable t = ds1.Tables.Add("Items1");
t.Columns.Add("Student ID", Type.GetType("System.String"));
t.Columns.Add("Student Name", Type.GetType("System.String"));
t.Columns.Add("Student Address", Type.GetType("System.String"));
t.Columns.Add("Student phno", Type.GetType("System.String"));
t.Columns.Add("Registration No", Type.GetType("System.String"));
t.Columns.Add("Start Date", Type.GetType("System.DateTime"));
t.Columns.Add("End Date", Type.GetType("System.String"));
t.Columns.Add("Course Name", Type.GetType("System.String"));
t.Columns.Add("Course Duration", Type.GetType("System.String"));
t.Columns.Add("Course Fee", Type.GetType("System.String"));
t.Columns.Add("Amount Paid", Type.GetType("System.String"));
t.Columns.Add("Balance Paid", Type.GetType("System.String"));
t.Columns.Add("Payment Date", Type.GetType("System.DateTime"));
t.Columns.Add("Receipt No", Type.GetType("System.String"));
DataRow r;
string reg = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
string id = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
OracleConnection ocon = new OracleConnection(ConfigurationManager.ConnectionStrings["toro"].ConnectionString);
OracleCommand ocmd = new OracleCommand("select s.STUD_ID,s.STUD_NAME,s.STUD_ADDRESS,s.STUD_CONTACT_NO,s1.REG_NO,s1.REGISTRATION_DATE,s2.COURSE_NAME,s2.DURATION,s3.AMOUNT,s3.PAIDAMOUNT,s3.BALENCEAMOUNT,s4.PAYMENT_DATE,s4.INVOICENO from sms_newreg s,sms_regis_info s1,sms_course s2,sms_payment s3,sms_receipt s4 where s.stud_id='" + id + "' and s1.reg_no='" + reg + "' and s.stud_id=s1.stud_id and s4.reg_no='" + reg + "' And s4.Course_name=s2.Course_name And s4.invoiceno=s3.invoiceno", ocon);
ocon.Open();
OracleDataReader dr = ocmd.ExecuteReader();
while (dr.Read())
{
r = t.NewRow();
r["Student ID"] = dr[0].ToString();
r["Student Name"] = dr[1].ToString();
r["Student Address"] = dr[2].ToString();
r["Student Phno"] = dr[3].ToString();
r["Registration No"] = dr[4].ToString();
r["Start Date"] = dr[5].ToString();
DateTime dt = new DateTime();
string dd, mm, yy,dt1;
dt1 = dr[5].ToString();
mm = dt1.Substring(0, 2);
dd = dt1.Substring(3, 2);
yy = dt1.Substring(6, 4);
string nd = mm + "/" + dd + "/" + yy;
dt = Convert.ToDateTime(nd);
dt = dt.AddMonths(Convert.ToInt32(dr[7].ToString()));
string d, m, y;
d = dt.Day.ToString();
m = dt.Month.ToString();
y = dt.Year.ToString();
if (d.Length == 1)
{
d = "0" + d;
}
if (m.Length == 1)
{
m = "0" + m;
}
string s = d + "/" + m + "/" + y;
r["End Date"] = nd.ToString();
r["Course Name"] = dr[6].ToString();
r["Course Duration"] = dr[7].ToString();
r["Course Fee"] = dr[8].ToString();
r["Amount Paid"] = dr[9].ToString();
r["Balance Paid"] = dr[10].ToString();
r["Payment Date"] = dr[11].ToString();
r["Receipt No"] = dr[12].ToString();
t.Rows.Add(r);
}
dr.Close();
ocon.Close();
PaymentPlan pp = new PaymentPlan();
pp.SetDataSource(ds1.Tables[1]);
crystalReportViewer1.ReportSource = pp;
crystalReportViewer1.Show();
}
catch (CrystalReportsException cre)
{
MessageBox.Show(cre.Message);
}
catch (OracleException oex)
{
MessageBox.Show(oex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}