Click to See Complete Forum and Search --> : UI and Data update


dohamsg
09-12-2008, 09:42 AM
Hi everybody,
SQL Server 2005 Database.
Delphi2007.

I'd like to know the best method for inserting and updating data, via User Interface.
1/ Should I use bound or unbound edit controls ( db controls ) to manipulate data in SQL Server database.

2/ For SalesOrder line table, should I use bound or unbound grid control ?

Please any suggestion.

Thanks indeed.

dohamsg
09-19-2008, 01:00 PM
I decided to use unbound edit controls for the User Interface.

Well I have no experience with stored procedures, I wish I had any advice on the following two stored procedures that update two tables linked one to one, is this technique sufficient to guarantee update?

http://rapidshare.com/files/146637039/CountryRUD.sql.html


Thanks indeed.