Could someone advise where I'm going wrong, I get an error message saying "Input string not in the correct format".
Here is the code that is giving the problems.
Thanks
Regards
Lemmo
// Create database connection
OleDbConnection thisConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = D:\Work\Databases\DataLink.mdb");
// Open Connection
thisConnection.Open();
// Create Adapter
OleDbDataAdapter thisAdapter = new OleDbDataAdapter("SELECT CustomerID, Customer, ContactName, TelephoneNo, EmailAddress, Add1, Add2, Add3, Add4, PostCode FROM Customers", thisConnection);
// Create builder to build SQL commands
OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);
// Create Dataset for data tables
DataSet thisDataSet = new DataSet();
// Fill data adapter
thisAdapter.Fill(thisDataSet, "Customers");
// Define primary key
DataColumn[] Keys = new DataColumn[1];
Keys[0] = thisDataSet.Tables["Customers"].Columns["CustomerID"];
thisDataSet.Tables["Customers"].PrimaryKey = Keys;
// Find row containing record to be deleted. TextBox1.text contains the name of the customer to be deleted
DataRow findRow = thisDataSet.Tables["Customers"].Rows.Find(textBox1.Text);
if (findRow != null)
{
MessageBox.Show("Deleting: {0}",textBox1.Text);
findRow.Delete();
thisAdapter.Update(thisDataSet, "Customers");
}
else
{
MessageBox.Show("Record Not In The Database");
}
thisConnection.Close();