C# Database Connection | Access Database | Database Connectivity in C# Application | C# Tutorial

C# Database Tutorial | Connecting Database in C# | Access Database Connectivity in C#
In this database tutorial, you can easily learn and understand, how to connect the database using c#. Here, table creation, data insertion and data retrieval has given with clear steps. So watch this video till the end for clear understanding.

Tools Support
Language : C#
Technology : ADO.NET
Architecture Model : Connected Architecture
Used Database : MS Access Database (Office 2016)
OS : Windows 10
IDE : Visual Studio

Note (Access DB)
- When you install MS office, then access database will be installed automatically
in your machine.
- Here I am using ms office 2016 version. you can choose any office version with access database.

Steps for Creating Database in MS Access
1. Open MS Access Database in Windows OS
2. Select Blank Desktop Database
3. Set the new name for the new database
4. Create table if you want otherwise leave (It is an optional)

Connecting MS Access Database in Visual Studio Project
1. CLICK THE SERVER EXPLORER (OPEN IT BY CLICKING VIEW
MENU IN IDE) IN THE CURRENT PROJECT OF VISUAL STUDIO IDE
- Right click the “Data Connections” menu and it will launch / display
the small popup menu for the input database selection.
2. CLICK THE BROWSE BUTTON AND SELECT YOUR INPUT
ACCESS DATABASE
3. Once you get "Test Connection Succeeded" then database will be successfully...
ETS Tutorial at Instagram
https://www.instagram.com/invites/contact/?i=1e1x0qj7xg658&utm_content=mvd6ubb