How ADO.Net operates on oracle Database

This article will explain in detail how ADO.Net operates on the oracle database. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

The first step is to write the connection string

You can write it in web.config.

The copy code is as follows:

And then call it in the background

The copy code is as follows:

String orclcon = ConfigurationManager.ConnectionStrings ["oracleson"] .ConnectionString

String orclcon = ConfigurationManager.ConnectionStrings ["oracleson"] .ConnectionString

Then create a new database connection object

The copy code is as follows:

OracleConnection conn = new OracleConnection (orclcon)

OracleConnection conn = new OracleConnection (orclcon)

Create an OracleCommand object to manipulate the database

The copy code is as follows:

OracleCommand cmd = conn.CreateCommand ()

OracleCommand cmd = conn.CreateCommand () Open the connection

Conn.Open (); the operation is fine.

The copy code is as follows:

Cmd.CommandText = "insert into dating 12 (AAAA) values (: a)"

Cmd.Parameters.AddWithValue (": a", TextBox1.Text); / / replace oracle database with: sqlserver database is @

Cmd.ExecuteNonQuery ()

Cmd.CommandText = "insert into dating 12 (AAAA) values (: a)"

Cmd.Parameters.AddWithValue (": a", TextBox1.Text); / / replace oracle database with: sqlserver database is @

Cmd.ExecuteNonQuery ()

This is the end of the article on "how ADO.Net operates the oracle database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.