Database Connectivity in C#

Database Connectivity in C# (Local Database)

  Hello, in this tutorial I am going to show you how to connect the C# application with the local database. So let's get Started.


Step 1: Create A local database file. I am using Access File.

Step 2: Open your C# project and go to the forms where you need a database connection.

Step 3: Use The Following Code To Connect with the database.

    1- need to include this statement in the code at the top. 

using System.Data.Oledb;
   2-need to write this statement in the class of that form.

OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\\psp\\lmsdb.accdb");

here the Source in the above code is the path of my Access file which I am using as a database.
the above code is to create a connection object of a database with a data source.

3-use this statement to open the database connection. you can write this code in button click method of the button.

con.Open();

4- within the same button click method you can write this code to display data from the table which is in that Access file.

OleDbDataAdapter dt = new OleDbDataAdapter("select * from [tblBooks] ", con); DataTable books = new DataTable(); dt.Fill(books); editTable.DataSource = books

here the editTable is the Data Grid View component name which I am using to display table data.
This is the code and output.