prime.pretilute.com |
||
ASP.NET Web PDF Document Viewer/Editor Control Library/// These properties allow the state to be used from the page member self.Text with get() = text and set(v) = text <- v member self.RepeatCount with get() = count and set(v) = count <- v /// This event is automatically wired up through the use of the /// AutoEventWireup ASP.NET directive (true by default) member self.Page_Load (sender: obj, e: EventArgs) = let acc = new Text.StringBuilder() for i in 1..count do acc.Append(self.Text) |> ignore self.Place.Text <- acc.ToString() The state and parameters of the control are ultimately held in the variables text and count. Note how we defined public properties (Text and RepeatCount) that will be available when we use the control from a page. All we need to use this user control from a page is to register it using the Register directive, giving a tag prefix and a tag name by which we can refer to it. For example, the code in Listing 14-12 results in an HTML label element containing the text Monkey! 10 times. Listing 14-12. TestRepeat.aspx: Using the Control from Listing 14-4 <%@ Page AutoEventWireup="true" %> <%@ Register Src="RepeatText.ascx" TagName="Repeater" TagPrefix="text" %> <!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>My User Control Test</title> </head> <body> <form runat="server"> <text:Repeater id="chart" runat="server" RepeatCount="10" Text="Monkey!" /> </form> </body> </html> You can find more details on implementing user controls in the books on ASP.NET referenced at http://www.expert-fsharp.com/Topics/WebProgramming. qr code generator visual basic 2010, onbarcode.barcode.winforms.dll free download, winforms code 128, gs1 128 vb.net, vb.net ean-13 barcode, pdf417 vb.net, itextsharp remove text from pdf c#, replace text in pdf using itextsharp in c#, data matrix vb.net, itextsharp remove text from pdf c#,The method _fetchArray() retrieves the array elements from the database using techniques we covered in earlier sections: private static ARRAY _fetchArray( Connection conn ) throws SQLException { PreparedStatement pstmt = null; ResultSet rset = null; ARRAY array = null; try { // Step 1 - prepare and execute the statement String stmtString = "select nt_col from number_table_nt" + " where rownum <= 1"; pstmt = conn.prepareStatement( stmtString ); rset = pstmt.executeQuery(); if( rset.next() ) { array = (ARRAY) rset.getArray(1); } } finally { JDBCUtil.close( rset); JDBCUtil.close( pstmt); } return array; } The method _runBenchmark() invokes the method timeMethod() (inherited from the JBenchmark class) to run the benchmark for each of the four cases. The first, second, third, and fourth methods are overridden to retrieve the array elements using the getArray(), getOracleArray(), getResultSet(), and getIntArray() methods, respectively. private void _runBenchmark( Connection conn, Object[] parameters ) throws Exception { timeMethod( JBenchmark.FIRST_METHOD, conn, parameters, GET_ARRAY_DESC ); timeMethod( JBenchmark.SECOND_METHOD, conn, parameters, GET_ORACLE_ARRAY_DESC ); timeMethod( JBenchmark.THIRD_METHOD, conn, parameters, GET_RESULT_SET_DESC ); timeMethod( JBenchmark.FOURTH_METHOD, conn, parameters, USE_NUMERIC_EXTENSION_DESC ); } Untyped XML vs. Typed XML The XML column created in the previous example is referred to as an untyped XML column because you did not associate an XML Schema. An untyped XML column can hold any wellformed XML document or fragment. This is useful if the column must accept several different types of XML documents or you do not have prior knowledge of the schema. SQL Server checks for well formedness before accepting XML into an untyped XML column, but it cannot validate the XML without an associated schema. Although untyped XML columns are flexible, if possible, you should define a typed XML column by associating an XML Schema. This enables SQL Server to perform validation and optimize storage and queries. The following CREATE script demonstrates how to define a typed XML column: CREATE TABLE Customer( CustomerID int, CustomerData xml (CustomerSchemaCollection) ) As this example shows, you specify the schema information after the xml type keyword. SQL Server 2005 uses schema collections to contain and manage sets of related schemas. So for this to work, you must first define the customer schema and import the schema into CustomerSchemaCollection. The following example demonstrates this: So far in this chapter we have looked at server-side web applications. In recent years a new class of rich-client web applications has emerged, leading to what is commonly called the Ajax development paradigm. This is a general term for any web application that incorporates substantial amounts of code executed on the client side of the application by running JavaScript in the web browser. We implement the first method to use getArray() method: public void firstMethod( Connection conn, Object[] parameters ) throws Exception { ARRAY array = (ARRAY) parameters [0]; int numOfRecordsRetrieved = 0; Object[] arrayInJava = (Object[])array.getArray(); for( int i=0; i < arrayInJava.length; i++ ) { numOfRecordsRetrieved++; } } We implement the second method to use the getOracleArray() method: public void secondMethod( Connection conn, Object[] parameters ) throws Exception { ARRAY array = (ARRAY) parameters [0]; int numOfRecordsRetrieved = 0; Datum[] arrayElements = (Datum[])array.getOracleArray(); for( int i=0; i < arrayElements.length; i++ ) { numOfRecordsRetrieved++; } } We implement the third method to use the getResultSet() method: public void thirdMethod( Connection conn, Object[] parameters ) throws Exception { ARRAY array = (ARRAY) parameters [0]; int numOfRecordsRetrieved = 0; ResultSet rset = null; try { rset = array.getResultSet(); while( rset.next() ) { Object object = rset.getObject(1); numOfRecordsRetrieved++; } } finally { JDBCUtil.close( rset); } } Fetch Size (Rows)
|
||