حفظ البيانات فى Pdf

يا ريت يكون السؤال واضح يا أخي

ما هي قاعدة البيانات؟ وما هي المعلومات بشكل عام؟

وما هو دخل ASP.NET هنا؟

اخي The Tornado

الف شكر ع سرعة الرد

انا استخدم

Visual Web Developer 2008 express

وقاعدة البيانات

SQL SERVER 2005

شكرا

هاك الحل ..

 

<%@ Page Language="C#" Debug="true" %>
<%@ import Namespace="CrystalDecisions.CrystalReports.Engine" %>
<%@ import Namespace="CrystalDecisions.Shared" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.IO" %>
<%@ import Namespace="System.Xml" %>
<%@ import Namespace="System.Text" %>
<script runat="server">
	public void Page_Load(Object sender, EventArgs E) {
		//*** INSTRUCTIONS:
		//define action for this program
		//1. set action to "CreateSchemaFile"
		//2. run program which creates your .xsd schema file
		//3. create crystal report based on that file
		//4. then set action permanently to "CreatePdf"
		//the command
		string action = "CreatePdf";
		//variables
		string tableName = "fin";
		string rptFile = "fin.rpt";
		string xsdFile = "fin.xml";
		string pdfFile = "fin.pdf";
		//either create the schema (first time only) or the pdf file
		if(action.ToUpper() == "CREATESCHEMAFILE") {
			DataTable dt = new DataTable();
			dt = DummyTable();
			DataSet ds = new DataSet();
			ds.Tables.Add(dt);
			CreateSchemaFile(xsdFile,ds);
			Response.Write("Your schema file has been created:<br/><br/> <b>" + Server.MapPath(xsdFile) + "</b><br/><br/>");
			Response.Write("Use it to create your Crystal Reports report file named:<br/><br/> <b>" + Server.MapPath(pdfFile) + "</b>");
		} else {
			//create the report document
			ReportDocument doc = new ReportDocument();
			string fileName = Server.MapPath(rptFile);
			doc.Load(fileName);
			DataTable dt = DummyTable();
			dt.TableName = tableName;
			DataSet ds = new DataSet();
			dt.TableName	= "Table";
			ds.Tables.Add(dt);
			doc.SetDataSource(ds);
			ExportOptions exportOpts = doc.ExportOptions;
			exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat;
			exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
			exportOpts.DestinationOptions = new DiskFileDestinationOptions();
			// Set the disk file options.
			DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
			( ( DiskFileDestinationOptions )doc.ExportOptions.DestinationOptions ).DiskFileName = Server.MapPath("fin.pdf");
			doc.Export();
			Response.Write(dt.Rows.Count);
			Response.Write("<a href=\"" + pdfFile + "\">" + pdfFile + "</a>");
		}

	}
	private void CreateSchemaFile(string fileName, DataSet ds) {
		string absoluteFileName = HttpContext.Current.Server.MapPath(fileName);
		FileStream myFileStream = new FileStream (absoluteFileName, FileMode.Create);
		XmlTextWriter myXmlWriter = new XmlTextWriter(myFileStream, Encoding.Unicode);
		ds.WriteXml( myXmlWriter,XmlWriteMode.WriteSchema );
		myXmlWriter.Close();
	}
	private DataTable GetTheData() {
		//get datatable
		DataTable dt = qs.GetDataTable("SELECT * FROM fin");
		DataTable d2 = dt.Copy();
		return d2;
	}
	private DataTable DummyTable()	{
		//create table
		DataTable dt = new DataTable("Employees");
		dt.Columns.Add("id",Type.GetType("System.Int32"));
		dt.Columns.Add("FirstName",Type.GetType("System.String"));
		dt.Columns.Add("LastName",Type.GetType("System.String"));
		dt.Columns.Add("HireDate",Type.GetType("System.DateTime"));
		//fill rows
		DataRow dr;
		for(int x=1;x<=10;x++) {
			dr = dt.NewRow();
			dr["id"] = x;
			dr["FirstName"] = "Joe" + x;
			dr["LastName"] = "Smith" + x;
			dr["HireDate"] = DateTime.Now;
			dt.Rows.Add(dr);
		}
		return dt;
	}
</script>
<!--#include file="qs.aspx" -->

http://www.developerfusion.co.uk/show/4266/

أنصحك أخي أن تذاكر شوي في Crystal Reports لأنه يمكنك من عمل تقارير وعرض لبيانات معينة .. وكذا يمكنك من عرض هذه البيانات إلى أي صيغة تريدها .. مثلاً HTML أو Excel أو Access أو PDF أو XML وغيرهم

حمل ال ABCpdf .NET