I have the following code, but get an error "Failed to connect to datasource"
Code:
OleDbConnection conn = new OleDbConnection();
// TODO: Modify the connection string and include any
// additional required properties for your database.
conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data source= C:\SerialNumber.accdb";
try
{
conn.Open();
// Insert code to process data.
string strCmd = "Select Code, Naam From ProductLine";
OleDbDataAdapter da = new OleDbDataAdapter(strCmd, conn);
DataSet ds = new DataSet();
da.Fill(ds);
this.cboProductLine.DataSource = da;
this.cboProductLine.DisplayMember = "Naam";
this.cboProductLine.ValueMember = "Value";
// make it readonly
this.cboProductLine.DropDownStyle = ComboBoxStyle.DropDownList;
//this.cboPruductLine.DisplayMember = "Naam";
//this.cboPruductLine.ValueMember = "Naam";
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source: " + ex);
}
finally
{
conn.Close();
}