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

The main content of this article is to explain "ADO.NET how to achieve database connection through drag-and-drop", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "ADO.NET how to achieve database connection through drag-and-drop"!

ADO.NET programming experiment steps (1):

First of all, right-click the toolbox pop-up menu, click "option" in the pop-up menu, select a series of ADO.NET object components such as SqlConnection in the selection toolbox that appears, put a check mark in the check box in front of them, and * * Click "OK", SqlConnection and other components appear in the toolbox. As shown in the figure.

Figure add component diagram to the toolbox

Experimental steps of ADO.NET programming (2):

Select the "data" tab in the toolbox, find the SqlConnection object component you just added, click and drag and drop onto the form, and the SqlConnection1 object appears in the component bar under the design window. Select the SqlConnection1 object, find the ConnectionString property in the properties window, and select New connection in the drop-down box on the right.

The design window pops up an add connection window (as shown). This window is dedicated to configuring the connection properties of the SqlConnection1 object. In the add connection window, first select the SQL Server server in the list, then specify the user and password, and then select the database to connect to. Click Test connection, and if the connection is successful, a success message will be displayed. At this point, you can see a long string of characters in the right column of the ConnectionString property of the SqlConnection1 object, which is the connection string. In the subsequent coding process, you can use the SqlConnection1 object to access the database.

Figure add data

At this point, I believe you have a deeper understanding of "ADO.NET how to achieve database connection through drag-and-drop form". 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.