Shulou(Shulou.com)06/02 Report--

This article mainly explains "how to use C# and ADO.NET". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to use C# and ADO.NET.

C # and ADO.NET

Accessing databases is part of most applications, and with the release of C # and ADO.NET, the process has become quite simple. This article shows the following four basic database operations:

1. Read the data. This includes different data types such as integers, strings, and dates.

two。 Write data. Just like reading data, we write these usual data types. This is achieved through the SQL statement.

3. Update or modify data. Let's use a simple SQL statement.

4. Delete data. Use SQL.

These operations are performed on a Microsoft Access 2000 database, but SQL or other ADO data sources can be used by simply changing the connection string.

Start the * step

To use the ADO class, we need to include the ADO.NET namespace (namespace) and some elaborate date classes. Add the following lines of code where you want to operate the database. It should be placed below the line of code introduced by the namespace and above the class definition.

Using System.Data; / / declare variable using System.Data.ADO; / / database using System.Globalization; / / date

Depending on the type of project you are involved in, you may need to add references to the System.Data namespace. You can judge whether the compiler generates an error after you add the above code. To add the System.Data namespace, you can:

1. Right-click in the Solution explorer-References branch.

two。 Select add reference

3. Select the .NET Framework tag.

4. Double-click the System.data.dll entry

5. Click OK

6.System.Data should now appear in the Solution explorer reference list.

Because the connection string is used in most operations, I recommend that you set it as a member of the class you want to write. Note: in your program, the path to the database file may be different. C# and ADO.NET are introduced above.

/ / attribute public const string DB_CONN_STRING = "Driver= {Microsoft Access Driver (* .mdb)};" + "DDBQ=D:CSTestDbReadWriteSimpleTest.mdb"; now that you have a better understanding of "how to use C# and ADO.NET", you might as well do it in practice! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.