C updating an access data base

You cannot undo the results of an update query, and making a backup helps make sure that you can reverse your changes if you change your mind.

How to back up your database When you need to update data from one table to another, consider the following rule: the data types for the source and destination fields must either match or be compatible.

Furthermore, when you update data from one table to another and use compatible data types instead of matching data types, Access converts the data types of those fields in the destination table.

Why this code is updating all the rows in the database? //Update Customers private void button5_Click(object sender, Event Args e) { string str2 = contact First Name Text Box.

updating is usually done with a primary key and in your case the customer-id is what you will need for updates. if you have the lastname in the where clause, there are still chances of updating multiple records if you have many customers with the same last name. private void button5_Click(object sender, Event Args e) { string str2 = contact First Name Text Box.

rusariadna.ru

48 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>