email: - nabil299@gmailc#.netvb.net asp.netcrystal reports.. crystal ,asp.netreports.. vb.net and...
TRANSCRIPT
![Page 1: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/1.jpg)
nabil299@Gmail .Com -: Email
![Page 2: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/2.jpg)
(ASP.NET)
![Page 4: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/4.jpg)
Crystal ReportsASP.NETVB.NET C#.NET
..
,Crystal ReportsASP.NET
VB.NET and C#.NET
..
ASP.NET VB.NET
Microsoft Visual Studio 2008
ASP.NET Web Site
Language
Visual Basic
location
File System
My Documents Visual Studio 2008
![Page 5: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/5.jpg)
Ok ...
..
db1
Microsoft
Access
tbl_Client
..
..
IDAutoNumber C_Name
Text
C_Phone
Text C_Address
Text
..
..
App_Data
File >>> New >>> Web Site My DocumentsVisual Studio 2008Your_WebSiteApp_Data
ToolBox
Crystal Reports
CrystalReportViewer
![Page 6: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/6.jpg)
...
Add New Item...
Solution Explorer
Add New Item...
Add New Item
CrystalReport
![Page 7: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/7.jpg)
Ok
Crystal Reports Gallery
![Page 8: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/8.jpg)
OK
Standard Report Create Wizard
Create New Connection
OLE DB ADO
...
Your_WebSite
Microsoft Jet 4.0 OLE DB Provider
![Page 9: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/9.jpg)
Next
Database Name
..
![Page 10: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/10.jpg)
Next
Finish
..
![Page 11: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/11.jpg)
tbl_Client
Next
Next
Next
![Page 12: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/12.jpg)
...
..
Finish
..
..
..
Default.aspx
CrystalReportViewer1
Choose Report Source
![Page 13: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/13.jpg)
New Report Source
Create Report Source
..
OK
![Page 14: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/14.jpg)
..
..
Build
Build Solution
![Page 15: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/15.jpg)
Build Succeeded
..
![Page 16: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/16.jpg)
..
..
..
..
Static
Default.aspx
...
.
Imports System.Data.OleDb Imports System.Data Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports System.Collections
Page_Load
..
Dim rpt As New ReportDocument rpt.Load(Server.MapPath("CrystalReport.rpt"))
Dim db As New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + Server.MapPath(".\\db1.mdb")) db.Open() Dim SQLs As String SQLs = "" Dim ad As New OleDbDataAdapter(SQLs, db) Dim da As New DataSet ad.Fill(da, "Earth")
rpt.SetDataSource(da) rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.DefaultPaperOrientation CrystalReportViewer1.ReportSource = rpt
db.Close() ad.Dispose() da.Dispose()
![Page 17: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/17.jpg)
:
...
..
SQLs = ""
..
CrystalReport.rpt
Field Explorer
![Page 18: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/18.jpg)
Show SQL Query
..
.. Default.aspx.vb
SQLs
ID= 1
![Page 19: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/19.jpg)
SQLs = "SELECT `tbl_Client`.`ID`, `tbl_Client`.`C_Name`, `tbl_Client`.`C_Phone`, `tbl_Client`.`C_Address`FROM `tbl_Client` `tbl_Client` Where ID=1"
..
..
Imports System.Data.OleDb Imports System.Data
Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports System.Collections
rpt
: Dim rpt As New ReportDocument rpt.Load(Server.MapPath("CrystalReport.rpt"))
..
![Page 20: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/20.jpg)
Dim db As New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + Server.MapPath(".\\App_Data\\db1.mdb")) db.Open() Dim SQLs As String SQLs = "SELECT `tbl_Client`.`ID`, `tbl_Client`.`C_Name`, `tbl_Client`.`C_Phone`, `tbl_Client`.`C_Address`FROM `tbl_Client` `tbl_Client` Where ID=1
SQLs
..
..
Dim ad As New OleDbDataAdapter(SQLs, db) Dim da As New DataSet ad.Fill(da, "tbl_Client")
.
rpt.SetDataSource(da)
..
rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.DefaultPaperOrientation
..
rpt
CrystalReportViewer1.ReportSource = rpt
db.Close() ad.Dispose() da.Dispose()
![Page 21: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/21.jpg)
SQL
..
C#.NET
using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OleDb; using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; using System.Collections;
Page_Load ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath("CrystalReport.rpt")); String SQLs; SQLs = "SELECT `tbl_Client`.`ID`, `tbl_Client`.`C_Name`, `tbl_Client`.`C_Phone`, `tbl_Client`.`C_Address`FROM `tbl_Client` `tbl_Client` Where ID=1"; String strConnection = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + Server.MapPath(".\\App_Data\\db1.mdb"); //create a new OleDbConnection object using the connection string OleDbConnection objConnect = new OleDbConnection(strConnection); //open the connection to the database objConnect.Open(); OleDbDataAdapter ad = new OleDbDataAdapter(SQLs, objConnect); DataSet da = new DataSet(); ad.Fill(da, "tbl_Client");
rpt.SetDataSource(da); rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.DefaultPaperOrientation; CrystalReportViewer1.ReportSource = rpt;
objConnect.Close(); ad.Dispose(); da.Dispose();
![Page 22: Email: - nabil299@GmailC#.NETVB.NET ASP.NETCrystal Reports.. Crystal ,ASP.NETReports.. VB.NET and C#.NET ASP.NET VB.NET Microsoft Visual Studio 2008 ASP.NET Web Site Visual Basic Language](https://reader033.vdocuments.us/reader033/viewer/2022050107/5f44fc6bc867bc1adc360c9b/html5/thumbnails/22.jpg)
ASP.net
ASP.net
ASP.net
.NET
VB.net, C#, C++.net, J#
JavaScript, Jscript, VBScript
XML
ADO.NET
Cascading Style Sheet CSS
a
Visual Studio.net
b
IIS
nabil299@Gmail .Com -Email:
ASP.NET3.5Visual
Studio 2008
336665077 967