Click here to Skip to main content
15,895,011 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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);
            }
Posted
Updated 1-Dec-12 7:41am
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900