How to display data from Access database? C#

private void Bsearch_Click(object sender, EventArgs e)
{
try
{
connection.Open();
OleDbCommand command = new OleDbCommand();
command.Connection = connection;
string query = "select* from Students WHERE Firstname LIKE '" + tbsearchid.Text + "'";
command.CommandText = query;
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
tbFname.Text = reader["Firstname"].ToString();
tbLname.Text = reader["Lastname"].ToString();
/*this part*/ tbmulti.Text = reader[(Course1: + "Course1") (Course2 + "Course2")].ToString(); // my access db has 10 courses colums course1 -course10
/*this part*/ tbavg.Text = reader[ provide the avg of the courses]
/*this part*/ tbmax.Text = reader[provides the max of the courses]
}
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex);
}

Hi,

Kindly go to below link it will help you with example -

https://www.aspdotnet-suresh.com/2015/03/insert-fetch-data-from-access-database-in-aspnet-using-csharp-vbnet.html

Hi Dear,

Here is an article with explanation go through this so that you will understand about insert / update /delete / retrive data using MS Access using C# in windows applications.

let me know if you need any help on this

https://www.c-sharpcorner.com/uploadfile/e628d9/inserting-retrieving-records-from-ms-access-2007-using-odbc/

Thanks

Hi, Go through the below link it will help you. https://camposha.info/course/csharp-all-one/lesson/csharp-ms-access-crud-datagridview-insertselectupdatedelete/