windows db appliation

  • Thread starter Thread starter t
  • Start date Start date
T

t

I am working on developing window application using vb.net, application is ms-sql data driven, I have different windows groups will have to access / permission to different menus and icons from tool bar.
any suggestion on good practices / sample application used as reference about securities and setting .


Thanks

Tim
 
To start with, use Datawindow.Net component available from Sybase. Its a
great tool. It will cut down your development time and coding considerably.
Its a proven techonology. Adding dropdown boxes etc are codeless. You can
also resue your data components. Printing, graphs, sorting and reporting
including composite reports with the same component is built in.
Join http://www.sybase.com/detail/1,6904,1031119,00.html.

As for Menu access:
1) Make it Database driven. Have a menu structure and security entities on
the database.
2) Create a Menu component that you can populate from database.
3) OnLoad or relavant method of a Form, check the privilege for user/form
combination in the database and set your options accordingly. For example,
user 't' may ahve query privilege on 'CustormeForm' but not update. Then let
't' open the form and view data but disable 'Update' or 'Save' options.
Also, if you are using Datawindow.Net, you will be able to ignore the changes
with one line of code 'updatepending=0' in one of its events.

Hope this helps.
Harshad
 
Back
Top