Tutorials to .com

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

ASP Database Related Articles


561: I wrote a database to export data to EXCEL class (ASP)
clsExport2Excel.asp <% 'Category of the beginning of Class clsExport2Excel 'Statement of constant, variable Private strFilePath, strTitle, strSql, strField, strRows, strCols Private strCn, strHtml, strPath Private objDbCn, objRs P...

562: add data dataGrid
Document code: test.aspx ===========================> <% @ Page Language = "C #" Debug = "True"%> <% @ Import Namespace = "System.Data"%> <% @ Import Namespace = "System.Data.SqlClient"%...

563: Classification of multi-line multi-column displays the contents of the database (part of the film server code)
The movies all the movies in the database according to three categories of each line displayed in the page. <TABLE border = "0" cellpadding = "0" cellspacing = "0" bordercolor = "# 39599C" bordercolorlight...

564: Import Excel spreadsheet data to SQL Sever Database
<% 'On Error Resume Next 'Import Excel spreadsheet data to SQL Sever Database By Dicky 2004-12-27 16:41:12 QQ: 25941 Function Open_Conn (SqlDatabaseName, SqlPassword, SqlUsername, SqlLocalName, SqlConn) 'Create database connection...

565: How to obtain the string of pixel size?
CSDN the entire contents of the new home page is currently updated manually, the heavy workload, one of the reasons for the reduction of the title of the article so that there is no long line situation. Could have been heading in the procedure to c...

566: Excel spreadsheet data into SQL Sever Database to Another method
The last to provide a spreadsheet from Excel into SQL Server database, a prerequisite for the machine to be equipped with components of Office's Excel. Again today for us to provide another way: do not need to install Excel can also be imported ...

567: The installation of SQL database and ASP to import data and the establishment of user
<% 'on error resume next action = request ( "action") IF action <> "install" THEN %> <BR> <center> <form method="POST" action="install.asp?action=install" name="form1...

568: No updated data set showed that two cases of
A result of recent site used without the need to refresh the data, so some information online, without the realization of the data setor use javascript to achieve xmlhttp or iframe. Online to find a code that can not be used instead of low efficienc...

569: [ASP.NET] on the Oracle database to create tables / data sheet to determine whether there is
Oracle database to create a table: Dim myConnectionString As String Dim myConnection As OleDbConnection Dim myCommand As OleDbCommand Dim myCreateSQL As String myConnectionString = "Provider = 'OraOLEDB.Oracle.1'; User ID = [User I...

570: SQL stored procedure in. NET database applications
1. Preface: Stored procedure (Stored Procedure) is a set of specific functions in order to complete the set of SQL statements, as compiled stored in the database. Users to specify the name of stored procedure and given parameters (if the stored pro...

571: Learning ASP Forum2.0 2 --- Notes understanding of Master Pages library
aspnet forums interface, first of all, the crux of the matter is that it used MetaBuilders control of Master Pages. To download this control http://www.metabuilders.com/Tools/MasterPages.aspx Department to look into: One, Master Pages includes fou...

572: Foot to achieve the datagrid to add a new data row to datagrid can not add data to solve the problem of
I have not used before datagrid, because we feel that the relatively low efficiency of the East, have to be a relatively simple things (very few field), but need to add amendments to delete, so wanted to try datagrid, modify, delete all added after ...

573: Efficient use of DataReader to access the database
When we connect to the database, a query after you want, you can display them on the page. Use a DataReader is the choice of saving server resources. DataReader provides a read-only, forward-only data access method, and therefore more complex data a...

574: On the DataGrid data into Excel garbled
When the guide data to Excel when sometimes garbled The original code private static void WriteToExcelFromDataGrid (DataGrid dg, string fileName) ( / / StringWriter tw = new StringWriter (new CultureInfo ( "zh-CHS", false)); StringWri...

575: To prevent Access database was downloaded
The core of the database on the site, and all are aimed at the SQL database intrusion of. Once the Web site to download the database was that even if your database is MD5 encryption, or violence can be broken Out. The user's information is miss...

576: ASP in the path of the database access problem
Usually do their own site is mostly used in SQL database, so the use of ACCESS database of the site do not have much contact. Yesterday to help a friend make a website using the ACCESS database management program background, encountered some trouble...

577: A landing window to determine the number of log entries (useful Oh), understanding of "IF" statement should be used
<% n = 0 adminID = Request ( "adminID") password = Request ( "password") if adminID = "" then%> <script language=vbscript> MsgBox "Error: Please enter the administrator user name!" location....

578: DataGrid and SQL Server 2000 Data Binding
DataGrid and SQL Server 2000 Data Binding WebForm page to add a DataGrid control DataGrid1, DataGrid control with the SQL Server manual bind only to getmouse, this is the binding code. First of all, add in the SqlClient namespace namespace. using...

579: Data Branch (arbitrary) output of the two methods
<! - # Include file = "connect.asp" -> <% 'set rs = server.CreateObject ( "adodb.recordset") /. Rs in connect.asp in the definition of sql = "select * from test message" rs.open sql, conn, 1,1 %> A...

580: Paging a good way to delete data (with exact and the abolition of the window), the search keywords (including spaces) handling
<! - # Include file = "connect.asp" -> <% Keyword = request ( "Keyword") Keyword = replace (Keyword, "","") page = Request.QueryString ( "page") sql = "select * from test papers wh...


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