protect.pdfjpgconverter.com |
||
ASP.NET Web PDF Document Viewer/Editor Control LibraryEmbedded scripts in web applications tend to create spaghetti code that confuses details of the presentation layer with the underlying logic of the application. However, embedding scripts is a useful way of trying new features. The normal practice for ASP.NET website development is for each Page.aspx file to have backing code in a particular language, such as Page.aspx.fs for F# code. Listing 14-4 shows the code from Listing 14-2 but without the embedded script and with ASP.NET directives at the top of the file indicating that a code-behind file is being used. Listing 14-4. Time2.aspx: A Simple ASP.NET Web Form with F# Code-Behind <%@ Page Language="F#" AutoEventWireup="true" CodeFile="Time2.aspx.fs" Inherits="FSharpWeb.Time2" %> vb.net qr code library, devexpress winforms barcode, winforms code 128, vb.net gs1 128, vb.net generator ean 13 barcode, vb.net pdf417 free, itextsharp remove text from pdf c#, replace text in pdf c#, vb.net data matrix barcode, c# remove text from pdf,_init_struct(true); setLine1(line1); setLine2(line2); setStreet(street); setCity(city); setState(state); setZip(zip); } /* ORAData interface */ public Datum toDatum(Connection c) throws SQLException { if (__tx!=null && __onn!=c) release(); __onn = c; return _struct.toDatum(c, _SQL_NAME); } /* ORADataFactory interface */ public ORAData create(Datum d, int sqlType) throws SQLException { return create(null, d, sqlType); } public void setFrom(AddressORAData o) throws SQLException { setContextFrom(o); setValueFrom(o); } protected void setContextFrom(AddressORAData o) throws SQLException { release(); __tx = o.__tx; __onn = o.__onn; } protected void setValueFrom(AddressORAData o) { _struct = o._struct; } protected ORAData create(AddressORAData o, Datum d, int sqlType) throws SQLException { if (d == null) { if (o!=null) { o.release(); }; return null; } if (o == null) return createFromFactory("AddressORAData", d, sqlType); o._struct = new MutableStruct((STRUCT) d, _sqlType, _factory); o.__onn = ((STRUCT) d).getJavaSqlConnection(); return o; } protected ORAData createExact(Datum d, int sqlType) throws SQLException { AddressORAData o = new AddressORAData(); o._struct = new MutableStruct((STRUCT) d, _sqlType, _factory); o.__onn = ((STRUCT) d).getJavaSqlConnection(); return o; } protected ORAData createFromFactory(String s, Datum d, int sqlType) throws SQLException { String sql = ((STRUCT) d).getSQLTypeName(); <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Current time</title> <style type="text/css"> body { font-family:calibri,verdana,sans-serif; } </style> </head> <body> <form runat="server"> The current time is: <asp:Label runat="server" id="Time" /> <asp:Button runat="server" id="Reload" text="Reload" OnClick="Reload_Click" /> </form> </body> </html> In turn, Listing 14-5 shows the accompanying F# code placed in a code-behind file. To place F# code in the code-behind file, we have done the following: Placed the code in a namespace. Defined a page type with the same base name as the .aspx page. The code generated from the .aspx file will use implementation inheritance to merge with the type defined here (see 6 for a description of implementation inheritance). This is standard practice for ASP.NET and matches the Inherits directive in Listing 14-4. Placed the implementation of the callback members into the page. Listing 14-5. Time2.aspx.fs: The F# Code-Behind for Time2.aspx #light namespace FSharpWeb open open open open System System.Web System.Web.UI System.Web.UI.WebControls When writing database code in a managed language, you can access all the functionality of the NET Framework The Framework contains thousands of useful classes, many of which provide functionality that s missing from and difficult to implement in T-SQL For example, the Framework provides rich string handling, regular expressions, cryptography, XML processing, image manipulation, file access, and much, much more Since the managed code executes within the SQL Server process, there is no need to marshal data across process Therefore, this is more efficient than using middle-tier components to implement the procedural logic In fact, SQL Server 2005 has a new server-side ADONET data provider that enables you to use standard ADONET calls to access the data In this way, you get the performance benefits of direct data access while using a familiar programming model. init(); AddressORAData factory = (AddressORAData)_map.get(sql); if (factory == null) { int p; if ((p=sql.indexOf(".")) >= 0) { factory = (AddressORAData)_map.get(sql.substring(p+1)); if (factory!=null) _map.put(sql,factory); } if (factory == null) throw new SQLException ("Unable to convert a "+sql+" to a "+s+" or a subclass of "+s); } return factory.createExact(d,sqlType); } /* accessor methods */ public String getLine1() throws SQLException { return (String) _struct.getAttribute(0); } public void setLine1(String line1) throws SQLException { _struct.setAttribute(0, line1); } /* Code for remaining accessor methods deleted for clarity */ public String getAddress () throws SQLException { AddressORAData __jPt_temp = this; String __jPt_result; /*@lineinfo:generated-code*//*@lineinfo:169^5*/ /* Some generated comments deleted for clarity */ { // declare temps oracle.jdbc.OracleCallableStatement __sJT_st = null; sqlj.runtime.ref.DefaultContext __sJT_cc = getConnectionContext(); if (__sJT_cc==null) sqlj.runtime.error.RuntimeRefErrors.raise_NULL_CONN_CTX(); sqlj.runtime.ExecutionContext.OracleContext __sJT_ec = ((__sJT_cc.getExecutionContext()==null) sqlj.runtime.ExecutionContext.raiseNullExecCtx() : __sJT_cc.getExecutionContext().getOracleContext()); try { String theSqlTS = "BEGIN\n :1 := :2 .GET_ADDRESS();\n END;"; __sJT_st = __sJT_ec.prepareOracleCall(__sJT_cc,"0book.ch10.jpub.AddressORAData", theSqlTS); if (__sJT_ec.isNew()) { __sJT_st.registerOutParameter(1,oracle.jdbc.OracleTypes.VARCHAR); } // set IN parameters if (__jPt_temp==null) __sJT_st.setNull(2,2002,"BENCHMARK.ADDRESS"); type Time2() = inherit Page() [<DefaultValue>] val mutable Time : Label [<DefaultValue>] val mutable Reload : Button else __sJT_st.setORAData(2,__jPt_temp); // execute statement __sJT_ec.oracleExecuteUpdate(); // retrieve OUT parameters __jPt_result = (String) __sJT_st.getString(1); } finally { __sJT_ec.oracleClose(); } } // ************************************************************
|
||