Detailed description of ODT. Net on accessing Oracle using sqldatasource

In the previous blog, I introduced how to use Oracle Developer Tools for Visual Studio. NET in combination,

This blog post will focus on how to access the Oracle database by using the sqldatasource control,

In fact, as long as the environment is well matched, the content of this blog post is too simple,

In other words, sqldatasource only constructs a database connection string through a visualized interface,

And some SQL statements and so on, and then the completed classes can access the database,

That is to say, but here we should note that,

The previous blog posts mentioned that using ODBC or oledb to access the Oracle database,

Two types of Oracle Database access through Visual Studio are also mentioned.

One is: the. NET Framework data for Oracle providesProgram

One is:. NET Framework data provider for oledb

In essence, there is another way to access the Oracle database through Visual Studio,

That is, Oracle data provider for. net,

This blog post describes how to use ORACLE data provider for. Net to access the database,

To make the demo more concise, I used sqldatasource directly,

Check the demo directly.

This Scott. Oracle is the connection established with the Oracle database when the environment is configured in the previous blog,

Scott represents Scott in the Oracle database,

The Oracle database represents the SID or database name of my database,

Currently, only one Oracle database is created on my PC, and its database is Oracle.

The entire page is designed, and no server line is used.Code,

The following figure shows the effect,

At this point, the entire demo is complete,

As a matter of fact, you may find that,

The demo in this blog post is not much different from the previous introduction of connecting Oracle databases in Visual Studio,

You may doubt the capabilities of Oracle Developer Tools for Visual Studio. NET,

In fact,

The above demo shows

Oracle Developer Tools for Visual Studio. NET is only the simplest function,

More features will be introduced later,

After installing Oracle Developer Tools for Visual Studio. NET,

Accessing the Oracle database will be as easy as accessing the SQL Server database !!!