C# Access Database | Read Access DB in C# | Connect Access DB in C# | Read Data from MS Access

Connection to database and Read DB in c# is very important. In this video we will Read Access DB in C#.First we will learn how to connect to Access db in C# then we will read data from Ms Access or Read Record from access db. When we successfully connect to access DB in C# and read access DB Record with C#.we will show that Read access DB in c# Records or row in a grid view. Access db is obsolete these days but you may come across where you have to connect to access db in c# and read all the records this video is a perfect solution for such situation. learn about connecting to access database and read the table content from access db. we will connect to access db in c# and then we will read all the content available in the db table and then we are going to show it in a data gridview using C# Code. code is here: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms;

namespace ReadingAccessDBFiles { public partial class Form1 : Form { public Form1() { InitializeComponent(); }

    private void browseBtn_Click(object sender, EventArgs e)
    {
        OpenFileDialog fileDialog = new OpenFileDialog();
        if(fileDialog.ShowDialog() == DialogResult.OK)
        {
            pathtextbox.Text = fileDialog.FileName;
            string nameFile = fileDialog.SafeFileName;
            string[] names = nameFile.Split('.');
            string name1 = names[0];
            MessageBox.Show(name1);

            if(pathtextbox.Text != "")
            {
                ReadAccessDB(name1, pathtextbox.Text);
            }
        }




    }

    public void ReadAccessDB(string name,string filePath)
    {
        string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath;
        string query = "select * from " + name;
        OleDbConnection connect = new OleDbConnection(connString);
        OleDbCommand command = new OleDbCommand(query, connect);
        connect.Open();
        OleDbDataReader reader = command.ExecuteReader();
        DataTable dataTable = new DataTable();
        dataTable.Load(reader);
        dataGridView1.DataSource = dataTable.DefaultView;
    }
}

}

If you want to connect access database with c# this tutorial is for you. in this tutorial i will show how to create access database and table than how to connect access database in visual studio using c# windows form application. next tutorial is complete crud operation in access database with visual studio using c#.net

Read Access DB in C# | How to connect and read Access DB Content in C# [ Step by Step Tutorial ] Read Access DB in C# | How to connect and read Access DB Content in C# [ Step by Step Tutorial ] Read Access DB in C# | How to connect and read Access DB Content in C# [ Step by Step Tutorial ] Read Access DB in C# | How to connect and read Access DB Content in C# [ Step by Step Tutorial ]

Programming Guru,Guru Programming,programming,gurru,programminggurru,connect to access db in c#,access db connection in c#,reading content from access db in c#,Read access db in c#,how to connect and read access db content in c#,c# microsoft access database tutorial,c# visual studio microsoft access database tutorial,connecting reading access database table

you do not have knowledge about the basic of java so follow the link below https://www.youtube.com/watch?v=8e9r1w3iFz4&list=PLIirX8GfWeRza33fMsWWb4LZQ7zRH5B4L

For C# beginner tutorial follow the following link https://www.youtube.com/watch?v=k5DPGtTYPzs&list=PLIirX8GfWeRyiy_4UTQMhE2EMBCuFgrUV

For C# Gui tutoral follow the Following link

https://www.youtube.com/watch?v=k5DPGtTYPzs&list=PLIirX8GfWeRyiy_4UTQMhE2EMBCuFgrUV ... https://www.youtube.com/watch?v=8nX6PSfq3_0