Introduction to Delphi Database Connection

dsn

1. BDE This is one of the most commonly used methods of Delphi. You can add a BDE alias to the BDE administration in the control panel. However, I am used to creating a BDE alias in SQL explorer, because after the table is created, you can directly

[Post] connecting to excel using ADO in Delphi

Feeling of using ADO to connect excel in DelphiBy panther666Today, I used ADO to connect to excel in Delphi (I have read it in a book before, and I will review it -_-!!), I have gained some benefits and do not dare to enjoy them exclusively.Part 1:1.

Several important system tables in SQL

1. sysobjects tableThe main system table sysobjects of SQL Server appears in each database, which contains a row of records for each database object. To query the table name in this database, you can use the following conditions: Use yourdatabase

Csung calls net.exe to send messages

By default, the Messenger Service of WINXP SP2 is forbidden. to use it, you must first start the service. // Send a messagePrivate void netsendmsg (string strip, string strhostname, string strmsg){Try{Process sendprocess = new process

Use Enterprise Library to improve your application system 3-Data Access Application Block

There is nothing to say, just summarize some best practices:1. advantages of using Windows security mechanism for database connection: high security; disadvantages: low performance.Advantages of database security mechanism for database connection:

Sqlserver date type conversion

ConvertExplicitly converts a data type expression to another data type. Because some requirements often use different date formats, the following can be found inFormat the date in SQL Server. SQL Server supports the use of KuwaitAlgorithmData

Write mathematical formula plug-in latexit

If you are a friend of the University, Research Institute, or in the academic field who is connected to the tech field, there should be some equations to be written when the computer is generating information. However, when using the yunguo series

Five data types in SQL

1. character: sql-92: Char, varchar MYSQL: Char, varchar & Binary, varbinary MSSQL: Char, varchar & nchar, nvarchar & Binary, varbinary ORACLE: Char, varchar2 (varchar), raw, nchar, nvarchar2, Note: varchar, raw must be set 2. text MYSQL:

Delphi manual dataset Creation

Used. net datatable, it is customary to think That Delphi also has similar things, the results have been done for a long time, it seems that it is achieved with Delphi. net idea, but it also solves some problems. 1. creatdataset: tdataset; The

Delphi dynamic creation and deletion buttons

 Unit unit1; Interface UsesWindows, messages, sysutils, variants, classes, graphics, controls, forms, Dialogs, stdctrls; TypeTform1 = Class (tform)Btnaddbutton: tbutton;Btndeletelast: tbutton;Procedure btnaddbuttonclick (Sender: tobject

Replace blank lines in Word

In the past, we found that the layout of the webpage is different from that of the word, and many soft carriage returns and blank lines may appear. As a result, I wrote an empty text row eliminator. Later I thought that Microsoft would not let it go.

Both the background and the pop-up panel have the animated modal effect.

Microsoft Ajax control toolkit contains the modalpopup control. You can implement page hiding. But the cover appeared directly and suddenly. Can I add a gradient? It feels better and more dazzling. So I thought that if the pop-up dialog box (panel)

Exception Handling Mechanism

Speak with Instances Static void main (string [] ARGs){String input;While (true){Try{Console. writeline ("enter an integer between 0 and 9 or press enter to exit ");Input = console. Readline ();If (input = ""){Break; // press enter to exit}If

View status viewstate

View status is a method used by default by the ASP. NET page framework to save the page and control value between the round-trip process. When the page is displayed in HTML format, the current status and value of the page to be retained during the

Detailed description of the boot. ini file

(1) Timeout = 5 Before you select the default Operating System, "timeout" indicates that ntlkr can be loaded from startup before the default Operating System is loaded.ProgramSelect the number of seconds for the operating system. If the value is 0,

First glance at SQL * Loader

SQL * loader is an Oracle Data Loading tool, which is usually used to migrate operating system files to Oracle databases.. SQL * loader is large dataRepository selection method, because it provides the fastest way (direct, parallel ). Now, let's

A query expression generator control

In the next step, Microsoft will launch its own MVC System (what is Kao and Java, and what it will do). It will no longer support traditional PostBack, that is, it does not support the traditional page generation cycle, this means that many server

About ref and out

In C #, parameters can be passed either by value or by reference. You can pass a parameter through reference to allow function members to change the parameter value and keep the change. To pass parameters through references, you can use the ref or

The Security Settings cocould not be applied... The reason is that the original items are not uninstalled clean.

When installing MySQL, you will encounter the following errors. It is not terrible to encounter an error. What you are afraid of is being knocked down by the error!The Security Settings cocould notBe Applied to the database because the connection

Reference of the median value in a Delphi SQL statement

1. directly use the value (number or string) Number: Select * from CC where no = 5; or select * from CC where no = '5' String: Select * from CC where name = 'dashan'   2. Use Variables VaR XX: string; SQL: widestring; ......... If

Total Pages: 64722 1 .... 54697 54698 54699 54700 54701 .... 64722 Go to: GO

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.