CODE
public void display(event_detail e)
{
string path = Directory.GetCurrentDirectory();
string connstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + @"\GameMuseumManagementSystem.mdb";
OleDbConnection conn = new OleDbConnection(connstring); //Create connection
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * from Event WHERE Event_Title ='" +PassName + "'", conn); //Create command
cmd.Connection = conn; //command connect to database
OleDbDataReader myReader = cmd.ExecuteReader();
while (myReader.Read())
{
e.notxt.Text = (myReader["Event_No"].ToString());
//e.notxt.ReadOnly = true;
e.titletxt.Text = (myReader["Event_Name"].ToString());
//e.titletxt.ReadOnly = true;
e.datedetail.Text = (myReader["Event_Date"].ToString());
//e.datedetail.ReadOnly = true;
e.detailtxt.Text = (myReader["Event_detail"].ToString());
//e.detailtxt.ReadOnly = true;
}
}
{
string path = Directory.GetCurrentDirectory();
string connstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + @"\GameMuseumManagementSystem.mdb";
OleDbConnection conn = new OleDbConnection(connstring); //Create connection
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * from Event WHERE Event_Title ='" +PassName + "'", conn); //Create command
cmd.Connection = conn; //command connect to database
OleDbDataReader myReader = cmd.ExecuteReader();
while (myReader.Read())
{
e.notxt.Text = (myReader["Event_No"].ToString());
//e.notxt.ReadOnly = true;
e.titletxt.Text = (myReader["Event_Name"].ToString());
//e.titletxt.ReadOnly = true;
e.datedetail.Text = (myReader["Event_Date"].ToString());
//e.datedetail.ReadOnly = true;
e.detailtxt.Text = (myReader["Event_detail"].ToString());
//e.detailtxt.ReadOnly = true;
}
}
this is my code,i has put this function in my case there,why i still cant retrive data from my access database ,is it the database problem??or ?because my access is version 2013 which is pirated version