Http://www.aspcn.com
Flying
Mobile control of Asp+
If media news and advertising are to be believed, we will be using small phones or other mobile devices to access the Internet in the near future. OK, this one
is a more optimistic estimate, but one
ASP (Active Server Pages) is a Microsoft company Dynamic access Network database
The latest technology is being used in web development more and more widely. ASP programming is very spirit
Live, this article through the development of a database
Date-type data is always a headache, whether it's an MIS or an intranet (INTERNET) development, because it's not handled like a number or a string.
Do what you want, but horseshoes the program.
In the development process of web-webserver-database
6 SQL Server is a server-level database, the use of more stringent requirements, you must enter a username and password to use.
Function createsqlserverrecordset (computer name, user ID, user password, database name data table or view table or
Will demonstrate how to create and configure a sample database using the SQL 7.0 server's Enterprise Manager. We will also demonstrate how to increase the number of users with the appropriate permissions so that data can be accessed from the Web
' On Error Resume Next
Action=request ("Action")
IF action<> "Install" THEN
%>
Fill in Installation information
SQL database administrator:
SQL database Password:
SQL database address:
Else
Struid=request ("Struid")
Strsapwd=request
Total (1,0) = "China Business Report"
Total (2,0) = "Recruitment network"
Total (3,0) = "51Job"
Total (4,0) = "Xinmin Evening News"
Total (5,0) = "Evening News"
Total (6,0) = "Southern Weekend"
Total (7,0) = "Yangcheng Evening News"
Total (1,1) =200
This procedure belongs to a special method. The scope of use is relatively limited, and there is a certain risk. Borrowed from the ASP in the back door of some methods. The following is the program code.
Dim remoteaddr
If Request.ServerVariables
1. General method of calling stored procedures
Let's assume that there is a stored procedure dt_users in SQL Server:
CREATE PROCEDURE [dbo]. [Dt_users]
As
SELECT * from Users
Return
Go
The first approach is to not use the command object, directly
This article used not to use the Adodb.command command, but simply did a adodb.recordset to execute the stored procedure.
Stored procedures:
' Establish Dbo.tse stored procedures in SQL
CREATE PROCEDURE [dbo]. [TSE]
@keyword varchar (=null), '
V. Create ASP files to display XML data (index.asp)
The function of this file is to read and display the XML data, first create an XML image and then read the XML into memory, and use DOM to isolate the
The data you want.
strSourceFile =
When I was developing the company OA system. I'm looking for a csdn menu. But there is this code on the Internet. But it's not database based, and it can't be managed by rights. I wrote one. There is only one program file and one database. But the
SQL = ""Set Rs = Server. CreateObject ("Adodb. RecordSet ")Rs. open SQL, TXconn, 1, 1If Rs. RecordCount ThenTopNum = 10' defines how many entries are displayed per pageQName = "Page" 'defines the variable name of the received Page number.Page =
# # Dim rs, dic# Set rs = createObject ("adodb. recordset ")# Rs. open "select * from ctat where aid = 15783", conn# 'Rs. open "select * from ctat where aid = 12850", conn# # Set dic = fAtPgnt (rs ("content"), 50000, request. queryString ("apid "))#
The following code is the post. asp file code, which is relatively simple and is not described. Var Nothing;Response. addHeader ("Cache-Control", "no-cahce ");If (! Session. Contents ("Chat_User ")){Session. Contents ("Chat_User") = "Guest ";Session.
Enter the user name and passwordUser name:Password: Source code:User logonIf Request. Form. Count = 0 then%>Enter the user name and password user name: Password: Dim userDim pwdUser = Request. Form ("username ")Pwd = Request. Form ("password
After a phase of asp learning, we will build a simple chat room based on the content we have learned. Although it is very simple, you can use it to master the basic process of creating a chat room, and can constantly improve its functions.The
Using ASP (Active Server Page) to compile personal webpages has become a dream of more and more personal website authors. ASP is a web scripting language. Its most important feature is database-driven and dynamic interaction. The introduction of ASP
Implement room functions and user display in asp chat roomsAfter I wrote the article "implementing the whispering function in asp chat rooms", many of my friends sent me a letter asking meAbout other advanced functions. Indeed, advanced functions
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.