Data | database one, ADO overview
ADO (ActiveX Data Object) is an optimized set of dedicated objects to access the database, providing a complete site database access solution for ASPs. The ADO object executes on the server side, and provides the
SSIS (SQL Server integration Service) is a very large new tool for improvement on the basis of DTS in SQL Server2000. Using the data flow and control flow separation, design and deployment of the separation of the architecture design, introduced
Can improve performance by maintaining record caching in the dataset locally. For example, you can store 10 of pages of data in a local connection object, query the data source for new data only when the user navigates beyond the first or last page,
ADO (ActiveX Data Object) is a new interface for the development of Microsoft database applications, a high-level database access technology built on OLE DB, even if you don't understand OLE db,com, it's easy to deal with ADO because it's very easy
Using the DataGrid control
The DataGrid control is a bound control similar to a spreadsheet, and can display a series of rows and columns that represent the records and fields of the Recordset object. You can use the DataGrid to create an
server| Error | Resolving the problem with SQL Server is that the most common problems users encounter are the failure of the connection. In general, there are two ways to connect SQL Server, one is to take advantage of SQL Server's own client tools,
Is the connection database still connected to the database using an ODBC system or file DSN? Replace it with an OLE DB provider, which is faster and does not require the use of DSN
According to the Library connection technology. With OLE DB
Javascript| tutorial using OLE Automation in JavaScript
5. How to handle an instance of an application
A document template is a connection between an application and the document it supports. There are two types of document templates: a single
Non-SQL Server databases such as IBM DB2, which are accessed in Visual Studio.NET beta version 1, typically use the ODBC method of Ado.net, while in Beta 2 the database is accessed using OLE DB methods instead.
The connection string in BETA1 is
visual| Programming | data | database
Non-SQL Server databases such as IBM DB2, which are accessed in Visual Studio.NET beta version 1, typically use the ODBC method of Ado.net, while in Beta 2 the database is accessed using OLE DB methods
8.3.5.2 to release OLE objects in the application
When an object is released to a form, the form has a Ondragdrop event. The object is defined as the source parameter in the Tdragdropevent method, and the Tdragdropevent method is used to handle the
The. NET Framework
Garbage collection
What is garbage collection?
Garbage collection is a mechanism that enables a computer to detect when an object can no longer be accessed. It then automatically frees the memory that is used by the object (while
Create | Stored procedures
Paste, only reference the Fso,pdf format can write their own, just like the logo language:
Creating a PDF from a Stored Procedure
Http://www.sqlservercentral.com/columnists/mivica/creatingapdffromastoredprocedure.asp
Do
Data | Database Summary:
This paper discusses the method and function realization of using ASP to access DBF, DBC, MDB, Excel, SQL Server data, and finally gives an example of accessing Excel database by using the function provided in this paper,
Data shaping (which can also be called Hierarchical recordsets)
If you are familiar with access, it is similar to a child table. When you use VB
Database development is the best choice for you.
This technology has a strong application environment,
Say in front
I'm not a dedicated visual FoxPro programmer, and it's been more than 10 months since the last time I wrote a complete application with visual FoxPro. Three days do not practicing, three days do not say oral life, I so long time not to
I also wrote an article BCB called Excel on CSDN. The thought and Stationmaster's "uses OLE to operate Excel (C + + Builder Edition)" is the same.
If we use the 2K operating system, we can find that if only the EXCELAPP.PR ("Quit") is used, the
ADO recently always see a netizen asked about ado.net and ADO about the difference and good or bad, think oneself in just contact. NET really have this doubt, now will my little understanding and experience to write, I hope to help you a bit! In
Connection Database | syntax
Edit Note: Learn these things, you will basically be able to complete the ASP on the database of all operations independently.
ASP Connection Database 11 ways--This article summarizes the use of ASP linked to a variety
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.