Tutorials to .com

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

ASP Database Related Articles


441: Using SQL backup and restore database SQL SERVER
<HTML> <HEAD> <TITLE> SQL Server database backup and recovery </ TITLE> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> </ HEAD> <BODY> <form method="post&quo...

442: Example page datarepeater
<% @ Page Language = "VB"%> <% @ Import Namespace = "System.Data"%> <script runat="server"> Sub Page_Load (ByVal Sender As Object, ByVal e As EventArgs) Dim Pgds As PagedDataSource = New PagedDataS...

443: Counter (database storage)
<% / / Program Name: Counter / / Author: magicfox / / Time: 10/14/2004 function setCount () ( var sql, DataSet; var DataSet; var err = new Error (); var result; DataSet = Server.CreateObject ( "Adodb.recordset"); sql = "...

444: Sql Server in order to use WaitFor
There are two purposes: 1, after a period of time delay in the implementation of For example: waitfor delay'00: 00:05 ' print 'delay in the implementation of five seconds! ' - 5 seconds after the implementation of print 2, when...

445: In DataGrid to create a pop-up window
This article from the proposal DotNetJunkie. He was initially asked us to provide a letter on how to create HyperLinkColumn in the DataGrid example to use, you can after the user clicks on this column to open a new window, showing the details of thi...

446: Validator controls continue to learn
Continue to study the Validator 1) RequiredFieldValidator - testing whether the object control input The main attributes are: ControlToValidate ErrorMessage Display Additional attributes: InitialValue Description: RequiredFieldValidator att...

447: ACCESS database on non-renewable inquiries
At the time of writing. Net program, so if a database access, people would often forget certain things, which can not access the database, and the reported fault is not very direct. For example: the implementation of a query can not be updated. In A...

448: In the DataGrid for the content of the interception
DataGrid in the use frequently encountered when the contents of the cell resulted in long line of text, this has caused a very simple page looks chaotic. The following ways to solve this problem. When the contents of the cell over a specified lengt...

449: Query a table on the maximum and minimum values of the problem
Have to see a post, is asked how the first (with a query) to query a table of maximum and minimum values, one of them answered this: (take Northwind's Products table as an example) select top 1 * from products order by UnitPrice union select ...

450: Events inside the datagrid, as well as associated itemCreat control events
/ / Create a handle to entrust private void dgOrderConfirm_ItemCreated (object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) ( if (e.Item.ItemType == ListItemType.Item | | e.Item.ItemType == ListItemType.AlternatingItem) ( CheckBox...

451: On the database connection
Not resolve the above issues, new problems came again. The book has to do with ADO.NET connection objects, but today the N times the experiment is not successful. Internet experts for advice, he said do not use ASP.NET is the basic of the ADO (Note:...

452: How to prevent users from submitting duplicate data
This article from the linguistic point of view, should be the original author, where the translation. Simple solution: The simplest way is when a user subsequent to the submission of your server-side controls the use of the code Response.Redirect ...

453: Database connection string collating
Chinese version of MSDN, the Arab-Israeli should not translate a lot of translation, or translation of a problem. I see the English version of the Chinese version of MSDN and the MSDN basis, according to their own experience with the database connec...

454: javascript events to trigger datagrid
Trigger javascript events public static void DG_ItemDataBound (object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) ( LinkButton l = new LinkButton (); if (e.Item.ItemType == ListItemType.Item | | e.Item.ItemType == ListItemType.Alt...

455: Characters split sql query
names = Split (session ( "city "),"|") i = 0 Conditions or with another query with more than sql = "select * from qizu where field like '%" & session ( "field ")&"%' and recycle = 1 and...

456: ADO object constant
<% '------------------------------------------------- ------------------- 'Microsoft ADO ' 'Copyright (c) 1996-1998 Microsoft Corporation. ' ' ' 'ADO constants include file for VBScript ' '-------...

457: Delete DataGrid edit mode dialog & limit the length of test TextBox
Delete DataGrid edit mode dialog & limit the length of test TextBox ...

458: ASP security detection and filtration function SafeCheck
'------------------------------------------------- ------------------------- 'Role: security string detection function 'Name: SafeCheck 'Parameters: CheckString, CheckType, CheckLength 'Description: 'Checkstring string t...

459: Space access to the database, the database has been in use for space
The implementation of the exec sp_spaceused Test code <% set rs = server.CreateObject ( "adodb.recordset") sqlstr = "exec sp_spaceused" rs.open sqlstr, conn, 1,1 if rs.eof = false then response.write rs (0) & rs (1...

460: To judge which contains a string of Chinese or English
<script language="vbscript"> class CNWord public str private sub Class_Initialize () set regEx = new RegExp regEx.IgnoreCase = True 'settings are case-sensitive. regEx.Global = True 'Set global availability. end sub p...


Page 23 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]