Tutorials to .com

Tutorials to .com » Asp » Database » ASP Database Related

ASP Database Related Articles


161: In the ASP of the use of SQL statements 11: Records and Statistics
To determine the number of database records, or records to determine how many reached a certain standard, which is not difficult to complete using ASP. If you use the correct cursor type, you can use RecordCount property to obtain the number of cour...

162: The use of SQL in the ASP statement of 10: view
If the page there are a lot of records, many cases, this information will be in accordance with the alphabet in descending order ascending order than the traditional show efficient. You are familiar with the use of the ORDER BY clause, you can easil...

163: The use of SQL in the ASP statement of 9: form operations
Form from a page out of the information is programmed in ASP frequently asked questions. However, the traversal through the transfer of records form how long it will be spent? It depends on the size of the database. GUI interface simple traversal cy...

164: The use of SQL in the ASP statement of 8: Random Number
The establishment of randomly generated HTML code is a relatively easy to achieve the characteristics of the ASP. You may create a "one day with" a rolling advertisement, etc., will only need a little embellishment to make your site a long...

165: In the ASP of the use of SQL statement 7: ORDER BY
Select from the Access database records the most frustrating pieces of things, what kind of order they are entered into the database in accordance with the order out how. Even if you used the Access environment to change the Sort By View records, da...

166: The use of SQL in the ASP statement of 6: store queries
When you query a time when relatively simple, each time starting from scratch to create SQL statements do not charge anything, but the complexity of the query is different each time from scratch to be wrong a lot of development. Therefore, when the ...

167: The use of SQL in the ASP statement of 5: the beginning of the implementation of
The SELECT statement in the Institute of Construction and use of the following do you learn how to use it. In your database tools available, this may mean that you have to press a reading of "implementation" button words. In the ASP page, ...

168: The use of SQL in the ASP statement 4: joint statement
So far we are talking about relatively simple SQL statement, if the recordset and then cycle through the standard query, then these statements are also able to meet some of the more complex requirements. However, why should have to taste it inonly o...

169: In the ASP of the use of SQL statement 3: LIKE, NOT LIKE, and BETWEEN
You have removed w in the above example the head records the usage of LIKE to see. LIKE judge is a very useful word symbols. However, in many cases it may be used to bring too much of your data, it is best to use it prior to use our brains in the en...

170: access database table name of a section of code
<% Call RenameTable ( "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c: \ example.mdb "," test "," changed ") Sub RenameTable (conStr, oldName, newName) 'Has to be OLE DB connection 'Create object an...

171: Database query in the question of special characters
In database query, it will often come across such a situation: For example, a user would like to query his database user name and his password, but just the user name and password with special characters, such as a single quotation marks, "|&q...

172: ASP how to use MYSQL database?
ASP how to use MYSQL database? MYSQL database to its short, convenient, fast and free a lot of advantages as a preferred site is currently Database, but are generally used a combination of PHP + MYSQL to develop a variety of dynamic pages, in fact...

173: Database Query Analyzer
Certainly a lot of people used Query Analyzer, this tool how I would not have said, we introduced the Web to the Query Analyzer, the interface in Figure 1, the use of ASP written. (Figure 1) Source as follows: <% dim conn dim connstr on err...

174: Shows the database stored procedure
It's no easy trick to see stored procedures in a database programmatically with a scripting language like ASP. If you're using MS Access, you're out of luck. Access provides no way to see the actual meat of a stored procedure although yo...

175: Combination of ASP and SQL application processing time
In the development of database applications, the processing time will always be issues, such as records of inquiries, such as a specified period of time. The following frequently asked questions on these, combined with some of their own experience, ...

176: rs.open sql, conn, 1,1 it is only right to move the cursor? Wrong
I do not know who is guilty of such a fault, we all have always thought that rs.open sql, 1,1 on the open a read-only forward only cursor. But yesterday inadvertently found rs.open sql, conn, 0,1 is open only to read-only cursor to move, I was chan...

177: How to correctly show the images in the database
Document 1: showimage.aspx.cs namespace ImageResizing ( public class MainDisplay: System.Web.UI.Page ( public void Page_Load (System.Object sender, System.EventArgs e) ( try ( System.Int32 _ImgID = System.Convert.ToInt32 (Request.QueryString [ ...

178: ADO database connection string Guinness (VP, Excel, Text, Sybase,. NET, etc.)
This page contains sample ADO connection strings for ODBC DSN / DSN-Less, OLE DB Providers, Remote Data Services (RDS), MS Remote, MS DataShape. Also included are ADO.NET connection strings for each. NET Managed Provider (SQLClient, OLEDB, and OD...

179: A simple SQL statement executor
Great to be divided into three documents: ljmdb.asp (link library files), entice.asp (sql statement to implement the main interface), entice2.asp (select Recordset) ==================================== ljmdb.asp <% set conndb = server.createob...

180: Disconnected an example of database connection
The use of disconnected Recordset is a key condition for the client to use a temporary table, that is, Designated Rs.CursorLocation = adUseClient or 3, the following is a complete Examples: demo-1.asp (online demonstration: http://www.aspcn.com/d...


Page 9 of 32
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]