예제 #1
0
파일: CryOrder.cs 프로젝트: engyasir/yasir
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            CryOrder rpt = new CryOrder();

            rpt.Site = this.Site;
            return(rpt);
        }
예제 #2
0
파일: View.cs 프로젝트: engyasir/yasir
        private void View_Load(object sender, EventArgs e)
        {
            con.ConnectionString = @"Data Source=DESKTOP-U9D8BHS\YASIR;Initial Catalog=INFOEMP;Integrated Security=True ";
            string         sql = "SELECT  Table_1.Employee_ID, Table_1.Full_Name, Table_1.Job, Table_1.Job_Degree, Table_1.First_job_Date, Table_1.Department, Table_2.Birth_Date, Table_2.Birth_Place, Table_1.Working_Years, Table_1.Place_Of_working, Table_2.Card_Number, Table_2.Gavernatore, Table_2.Relajon, Table_2.Street FROM  Table_1 INNER JOIN  Table_2 ON Table_1.Employee_ID = Table_2.Information_ID";
            DataSet1       ds  = new DataSet1();
            SqlDataAdapter dad = new SqlDataAdapter(sql, con);

            dad.Fill(ds.Tables["OrderTable"]);
            CryOrder ord = new CryOrder();

            ord.SetDataSource(ds.Tables["OrderTable"]);
            crystalReportViewer1.ReportSource = ord;
            crystalReportViewer1.Refresh();
        }