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

Editor to share with you how to use the ADO.NET database, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

If you use the ADO.NET database, install it in the ADO.NET database, display icons on the toolbar, and then drag a data adapter onto the designer surface, you will not succeed. I can't do this. Only leave the reader a general impression for future study!

Unfortunately, I was fired in this Microsoft upgrade (of course, RecordSet can also be implemented through Page ASPCompat = "True", but it is not recommended). We have to learn new objects to manipulate the data recordset. The main objects in ADO.NET include: DataReader, DataSet, DataAdapter

From the example above, you can see that the DataReader object is somewhat similar to RecordSet, and the ADO.NET database is only used to read data! OleDbConnection is used to connect to the database, and OleDbCommand is the creation command. It can also be used to execute a command, and some examples are given below.

Sub Page_Load (sender As Object, e As EventArgs) 'connect to the database and open Dim conn As New OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0 Data Source= "& Server.MapPath (" test.mdb ") conn.Open () Dim sql =" UPDATE [book] SET Name = 'updated content' WHERE ID = 5 "'create COMMAND command Dim cmd As New OleDbCommand (sql, conn)' execute UPDATE cmd.ExecuteNonQuery () conn.Close () End Sub

Cmd.ExecuteNonQuery () executes the associated SQL statement, and the ADO.NET database only needs to change the variable SQL assignment if it wants to execute DELETE and INSERT statements.

DataSet is equivalent to a WEB version of the database, while ADO.NET database is used to move data from the database to DataSet, and then move the DataSet modified data back to the database. It can be said that it serves as a bridge between DataSet and database. Using DataSet can not only reduce the pressure on the database, but also easily manipulate the data through the attribute methods provided by DataSet!

The above is all the contents of the article "how to use ADO.NET Database". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.