Current location - Loan Platform Complete Network - Big data management - How to test a large amount of data to a database such as SQL, it is better to provide the steps, thank you!
How to test a large amount of data to a database such as SQL, it is better to provide the steps, thank you!
To save data to a database, VB comes with features that can't be done unless you save the data in a normal file.

With ADO is relatively simple, for your problem just a Connection object. Connect to the database with it and use its Execute method to execute the SQL statement that updates the data.

If your input corresponds directly to the database fields, you can also use data binding, use ADODC control to get the data and bind the text box to ADODC.