Createparameter parameter description (ASP)
Createparameter parameter description (ASP)Cmd. createparameter ("parameter name", type, direction, size)Cmd. createparameter name, type, direction, size, ValueThe value of data type and its
1. asp calls the Stored Procedure
First, create a database in SQL called it. I won't talk about how to create it. This is simple and I will know it at a glance. Create a table in the database and write several data records as follows:
Stored Procedures | access
what is the benefit of using SQL stored procedures The SQL stored procedure executes much faster than the SQL command text. When an SQL statement is contained in a stored procedure, the server does not have to parse and
1, call a stored procedure without parameters
Set Conn=server. CreateObject ("Adodb.connection")
Set Cmd=server. CreateObject ("Adodb.command")
Conn. Open strconn
Set CMD. Activeconnection=conn
In fact, Microsoft has a very good data operation class in its enterprise database. however, many companies (at least some of the companies I met ...), I don't dare to use something "encapsulated"
In fact, Microsoft's corporate library has a very good data manipulation class. But, a lot of companies (at least I met a few ...), some of the "encapsulation" of what things are not too bold, although I recommended the Microsoft Enterprise Library
Usually when we develop the use of database access Help classes, we individually write the appropriate data access Help classes for a particular type of data, such as Sqlhelper,oraclehelper,oledbhelper, In fact, all of these help class
Dynamic Preface: Many Web designers may have faced the problem of designing a form for users to input, the user entered the content into the database, but the user input is not the type of content (numeric field but input text) Situation or the user
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:
and provide relevant evidence. A staff member will contact you within 5 working days.