This is my first 3 tier application... I'm using a Stongly Typed Dataset as DAL. After everything was finished, I realized I had to make 2 changes to the database:

1- Add a new column

2- Change a SQL Data type from int to Bool

What is the best way to update my Strongly Typed Dataset and make sure everything will work fine?

 Thanks,

Rubens
 

In the DataSet designer, right click on the DataTable object that has changed and click configure.  Walk through this wizard to the end, and it should update all of your methods.  After a rebuild, you might see some errors complaining about "No overload accepts x number of parameters," which is what you want to see.

Thanks for your reply.

The Data Set was updated, however the stored procedures were not. Do I have to update them manually?

you can update them manually... or you can delete them and run through the wizard again to re-create them.

Thanks Matt!

How about the .xsd file and the classes that are created by Visual Studio? Should I delete them as well?

Nah, the wizard will bring them up to date.