The following is the stored procedure (sqlserver2000)
--
most common paging stored procedures
--
gets the data for the specified page
CREATE
PROCEDURE
pagination
@tblName
varchar
(
255
),
--
Table name
@strGetFields
varchar
(
1
Example of a database connection string using DSN:
MS Sql/mysql/postgresql
"Dsn=dsnname"
Do not use DSN database connection string Example:
MS Access
via OLE DB:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:somepathmydb.mdb; "
MS SQL
Through
Use components to protect your ASP code
Before we talked a lot about the security of Open database connection, now I put forward a kind of thinking
Use an ActiveX DLL to protect your code. (You don't have to worry about using shared encryption
C + + insertion sort includes binary insert sort code, in the direct insert sort, array data for the sorted elements, n for the number of elements to be sorted, and also includes the elements in the data array in hill sort, n for the size of the
ASP is an abbreviation for Active Server page, meaning "dynamic servers pages." ASP is an application developed by Microsoft to replace the CGI script program, it can interact with database and other programs, it is a simple and convenient
Directly start to build ASP server, we work together.
Web service extensions, other than the 12th item, are allowed.
Open Internet Information Services (IIS) Manager
Click the properties of the default Web site
Click Home Directory
1. Rs.Open Sql,conn,a,b,c2. Conn.execute (SQL,ROWSAFFECTED,C)
First, Conn.execute (SQL,ROWSAFFECTED,C)
Parameter meaning:
The SQL value can be either an SQL statement, a table name, a stored procedure name, or any string that the data provider
ASP tutorial. NET implementation XML insert and delete node information code
The following implementation inserts node information into the appropriate location in the XML file
Let's say we want to change the original XML file structure by
Mailbox Authentication Code Aexample30function chkemail (email) ' Define ProcessChkemail=true ' initialization function resultNames=split (email, "@") ' The Split function is to split the string into multiple substrings with the specified characters
ASP Cookies Tutorial is to record the user browsing information, but cookies can only save information to the client, but not also safe, many simple votes are used for cookies oh.
The same ASP session, ASP technology cookies are used to store
Dim wstr,str,url,start,over,dtimeUrl= "http://mb.111cn.net/"Wstr=gethttppage (URL)Body=wstr
' Use ASP to get Remote target Web page specified contentOn Error Resume Nextserver.scripttimeout=9999999function Gethttppage (path)t = getbody
12. Personalization12.1 provide personalized services for visitors12.2 personalization in ASP. NET12.2.1 user device filesNo and private, the core of ASP. NET personalized services when the user's device files are heartless.12.2.2 personalized
------------------------------------------------------------------------------ Iis web is favored by many people because of its simple management and support for ASP. This section describes how to use resin to enable IIS to support jsp and servlet. 1
Recently, I just created a project that requires that the data extracted from the series Data Library on the asp page be saved as an excel file, at the beginning, I finally thought about it and shared it with you !!-----------------------------------
---- Active Server Pages (ASP) is the script compiling environment on the Server. You can use it to create dynamic Web Pages or generate powerful Web applications. ASP makes this work very simple. ASP pages are files that contain HTML tags, text,
Solution to the connection problem between ORACLE920 and ASP The code is as follows:On error resume next'Connect to the database Set OraSession = CreateObject ("OracleInProcServer. XOraSession ")Set oradatabase = orasession. dbopendatabase
Transmission protocol: it can be http, https tutorial, tcp, named pipe, or msmq.Message Encoding: describes how to format a message. It can be binary, text, or mtom.Message version: it can be soap1.1 or soap1.2. You can also set whether the message
Asp tutorial. net web. config configuration file node descriptionWeb. the config file is an xml text file used to store the configuration information of the web application of the asp.net tutorial (for example, the most common method for setting the
1. Obtain the system time:2. Obtain the IP address used for access:3. Obtain the system and browser version:4. Remove IE hybrid bars:5. Enter the website and jump out of the advertisement:6. Random number:N is a changeable variable.7. Upstream mixed
Apache is a widely used network server program. It is not only widely used on UNIX/LINUX platforms, but also many websites on Windows platforms that have abandoned IIS and switched to Apache.. NET is a powerful development technology launched by
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service