You have to escape your string values:
string Query = "UPDATE Customer SET Customer name='" + textBox2.Text +"' WHERE Cnic='" + textBox9.Text + "'";
Also, update statements don't return a data set, so you need to use an OleDbCommand and then use the ExecuteScalar or ExecuteNonQuery to run the update statement.