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

This article introduces the relevant knowledge of "how to update ADO.NET management data". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Replace the ADO.NET management object. However, we can see that SELECT queries usually need to use either a DataReader or a DataSet if the data needs to be updated.

For example, the DB2Connection component includes an additional method that can be used to force the release of connection pooling resources. By default, ADO.NET management providers can share and reuse connections, which saves resources, but also means that connections are always open for possible reuse. This approach gives you more control than can be provided through drivers such as SQL Server-managed providers.

Although database-specific components provide a lot of flexibility, they do not lead to portable code. Maybe it's this annoying feature that makes you want to switch from one database to another. With this in mind, ADO.NET management creates Borland Data Provider (BDP).

BDP is a regular managed .NET data provider, but it's a little different. Instead of using only one database, ADO.NET management, it can use many different servers. The actual driver is determined by the connection string (or ConnectionString property) passed to the BdpConnection object when it is created.

So to connect to SQL Server using BDP, you can use:

BdpConnection myConn = new Borland.Data.Provider.BdpConnection ("assembly=Borl and.Data.Mssql,Version=1.1.0.0, Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b;ve ndorclient=sqloledb.dll; osauthentication=False;database=;usernam estrangement playing hostname; password=;provider=MSSQL")

Although the join syntax is slightly different, the object returned is the same. That is, all other code has not changed. You can even store the string in a resource file and reference it at run time. Borland provides an Connections Editor,ADO.NET management form that designers can use to create connection strings.

I can create another project in another instance of C#Builder, where ADO.NET management places a bdpConnection object on Windows Form, and then uses the clipboard to copy the connection string to a resource file in the application I'm writing.

This is the end of "how to update ADO.NET management data". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.