vs.net - / vb.net 2005

[Pete Newman]

I have been using vb6 and vb.net(2003) to date I have recieved a trial version of VS2005 and would like to try and create an Intranet application. I am basicly looking to generate a secure menu system running against our 2005 SQL Servers. I may be trying to run before i can walk, but thats just me. Id like to have a logon tested against a SQL table. on a sucessfull logon go to a 'page' that displays a datagrid form a different table. I would also need to know how i can stop direct access to the second page bypassing the logon page, and also preventing the use of the back button from the second page to the logon page. Its a lot to ask, but i think from this information it will give me a good base to learn from if anybody can point me in the right direction, i will be very greatfull

I really do need help..... all this computer stuff is way over my head !!

[Dave Sexton]

Pete Newman wrote:

Id like to have a logon tested against a SQL table.

You can still use methods from VS2003 to perform a logon in VS2005. Or do you want to make use of the new login controls[^]?

Pete Newman wrote:

on a sucessfull logon go to a 'page' that displays a datagrid form a different table. I would also need to know how i can stop direct access to the second page bypassing the logon page, and also preventing the use of the back button from the second page to the logon page.

I'd suggest creating the aspx page with the datagrid that's bound to your datasource and control access to that page using roles in the "User" object, e.g.

If User.IsInRole("Admin") Then
Response.Redirect("datagridpage.aspx")
End If

Not sure how or why you want to disable the back button to the logon page. You could add code in the PageLoad event of the second page to conditionally check whether or not the current user has viewing permission for the page - if they don't, redirect them to the logon form. This would really only apply if/when they typed in the url for that page directly (otherwise it would already have been checked through your logon procedure). Does that help at all?

[Pete Newman]

kulazfuk, Thanks for the response. the second part of your reply is very usefull thank you , however its the first part im still stuck on. I'll give a little background on what im atempting to do.. maybe you can suggest the best route we have an old VB6 application which resides on each users work stations and access the main SQL server .. im trying to create a simple trial 'Intra-net' project to see if the vb6 application can be replaced. Currently in the vb6 app, the user logs completes a logon name and password which is queired against an Operators table in the main database on the main server. im trying to replicate the same sort of logon on .. Idealy id love to use the build in login controls but , honestly dont have a clue how to this is my first attempt at an 'intra-net' so i need all the help i can get. I have looked for tutorials with no sucess :-(

I really do need help..... all this computer stuff is way over my head !!

[Dave Sexton]

Hi Pete, If you're not too worried by a deadline for this I would suggest you write your own logic for login operations before you start making use of the built in controls, that way you'll have a better understanding of why they behave as they do. Build a few sample applications to test it out, the best way to learn is to try. Click on the link I gave you in the previous post for an overview of the new ASP.NET login controls, from there onwards you'll find many links regarding web site security, membership and more. Also, do you have any experience in developing? Although I know you'd rather have this as a web application to run off your intranet, if you're bound to a deadline perhaps you could look at making it a desktop app? You may find that easier.

[Pete Newman]

Hi Kulazuk, Thanks again for the pointer. Im off to have a play ..... If i get stuck i know where to come back to :) PS the link is very usefull

I really do need help..... all this computer stuff is way over my head !!