windows db appliation

TheMSsForum.com: The Microsoft Software Forum

This is a multi-part message in MIME format.

------=_NextPart_000_0044_01C4D7C1.3EEF59F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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
------=_NextPart_000_0044_01C4D7C1.3EEF59F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1476" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><FONT face=3D"Times New Roman" color=3D#000080>I am working on =
developing=20
window application using vb.net, application is ms-sql data driven, I =
have=20
different windows groups will have to access / permission to different =
menus and=20
icons from tool bar.</FONT></DIV>
<DIV><FONT face=3D"Times New Roman" color=3D#000080>any suggestion on =
good practices=20
/ sample application used as reference about securities and setting=20
.</FONT></DIV>
<DIV><FONT face=3D"Times New Roman" color=3D#000080></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Times New Roman" color=3D#000080></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Times New Roman" color=3D#000080>Thanks</FONT></DIV>
<DIV><FONT face=3D"Times New Roman" color=3D#000080></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Times New Roman"=20
color=3D#000080>Tim</FONT></DIV></DIV></BODY></HTML>

------=_NextPart_000_0044_01C4D7C1.3EEF59F0--
Top

RE: windows db appliation by HarshadRathod

HarshadRathod
Thu Dec 02 11:29:10 CST 2004

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

"t" wrote:

> 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
Top