Welcome to FoxLearn
In this tutorial, I'll show you how to connect to the Microsoft Access Database in Visual Basic .NET
To connect to the Microsoft Access Database in Visual Studio, you can select Data Sources on the left side, then select the additional icon to connect to the database
Next, You need to change your data source to the Microsoft Access Database file, then select the Microsoft Access Database file you want to connect
Finally, you need to check the connection, if the connection fails, you need to install the Microsoft Access Engine
then close and reopen your visual studio to reconnect the Microsoft Access Database.
Open your form designer, then drag the DataGridView control from your Data Sources on the left side to your winform.
As you can see, Visual Studio automatically creates BindingSource to help connect data between your application and database.
The BindingSource component serves two purposes.
First, it provides a layer of indirection when binding the controls on a form to data.
This is accomplished by binding the BindingSource component to your data source,
and then binding the controls on your form to the BindingSource component.
Second, the BindingSource component can act as a strongly typed data source.
Now open the app.config file, then you can see the connection string is automatically added to the configuration file
You can select the control type for each property, then drag the properties you want to display details to your Form.
Thank you for watching this video and don't forget to subscribe to my channel