That would be nice. Waiting to hear from you ....

Many Thanks.

Ok I have started a new thread, from the very basics of the Login Page. This is a little more than your basic page, but it is still relatively simple. Cut and Paste the code into a new project following my steps and you should have no problems.

Enjoy!

New Thread

hello ,
i ve reffered ur asp.net login form creation but i m not getting that will u tell me in more broader way so that i can do by reffering ur code .i did same thaing what u gave in ur thread but i m not getting will u tell me simpler way to create the login page ,actually i m creating the issue list for the company i want to use this login page as-->
first when we open the logine page it must contain
name of employee: _________
Password :__________
Enter
when we enter it should show the issue list of that employee.
will u plz help me to do this in my project.
thank u
waiting for ur reply.

above error i m getting in my application


Compiler Error Message: BC30035: Syntax error in line 6

Source Error:



Line 4: ' Insert page code here
Line 5: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 6: Imports System.Web.SecurityLine 7: Imports System.Data
Line 8: Imports System.Data.OleDb

See the updated link! But this code is functional. And why are your imports after the Page_Load Event, they must appear before the class declaration.

So please check your coding. Even copy and paste is not simple if you paste it in the wrong spot...all depends on where you cursor is. Right?

So line 6, 7 , and 8 are in the wrong spot.

Hope this helps

Would love to help. First, use the new thread link above to see a more refined code.

Broader way? Not sure what you are saying I said by that? Sorry, please help me to understand.

And You want to change what, how the Login Box appears. It should say Name of Employee instead of Username? And Password will remain the same? Is that what you are saying?

And what is this list you are referring to? What list? Where?

Please....I would love to help, but you MUST BE CLEAR about what you are asking or having problems with, REMEMBER I am not working on the same thing you are, so I need to have it in detail if you wish me to help you.

Please send me a private message with the details if you do not want to post them here.

And use the UPDATED LINK to the NEW THREAD for the most up to date listing of this CODE!

thank u for ur reply.
actually i m developing one website for one company ,that website contains many things like in its sumenu it contains issue list ,time sheet, team activities etc ,so when i click on the issue list submenu it should link to the issue list page where i should enter following things

employee ID:_______
Password :_______
ya u r correct password should remain same ,in the employee ID we r storing each employees id's and in password we r storing password of each employee which r given by the comapny itself, so now when i enter employee ID and password of each employee it should open the page containing the issue list of that employee .
so how to do this. hope this time u understood what i want to tell .
plz send me reply as soon as possible ,i want the code for this ,i m trying it since from 1 and half month but i m not getting this when i saw ur site i felt as if i got the solution.plz help me.
thank u.

OK I think I have a better understanding of what you are trying to do, but dont see where you are having the difficulty. You have a selection from an Issue list Menu and then following the selection the employee must login and then a page will open with the issue list they selected. Let me see if this helps.

So this Login page is the second part to your Event(s) path. So, create the page with the Menus on it (i.e. Team activities, etc) which are apparently visible prior to login, which I don't understand, but again I am not working on this project so I am a little fuzzy on the details. Never the less, you would then have this login page to validate the Employee, and then the default.aspx would display the issue list of that employee.

Simple. The data for that issue list for that specific employee would have to be stored in the database (SQL , Access or Oracle for that matter) and would be related to the employee in some way. So like the login you are retrieving the data based on specific criteria being supplied. In the case of the issue list if the login is successful the retrieved data (issue list) will be specific to the employee thus part of your where clause in the SELECT statement / or Query.

So for example, without knowing your ERD (Entity Relationship Diagram) or the Data Structure for the project I would have the following;

Following tables with the following columns

tblLogin

• EmployeeID (Would have to be Unique, and thus No Duplicates Allowed)
• Password

tblEmployee_IssueList

• EmployeeID
• IssueListID
• Miscellaneous (Any other columns you feel you need here)

tblIssueList

• IssueListID (A UNIQUE Value, No Duplicates)
• IssueList_Desc (Details for that IssueList)
• Miscellaneous (Any other columns you feel you need here)

tblLogin 1 : N Relationship to tbl_Employee_IssueList N : 1 Relationship to tblIssueList

N = Many
1 = One

Assuming you are using SQL, but the same principles apply to Access and using the Query Builder
So your SELECT Statement would be something like this for retrieving the Issue List Details or Description :

SELECT IssueList_Desc
FROM tblIssueList
WHERE IssueListID = @IssueListSelected

Where the @IssueListSelected will be passed to this from the selection from the menu by the employee. I would store the value in a session variable which can be passed from the initial selection page to the Login Page which will use it once the login is successful.

This SELECT would be in a stored Procedure in SQL or a param Query built in Access (depending on your backend joice for the data access layer).



Hope this helps

Thanks for the code Paladine. I am working with SQLServer DB version. When I ran it, I got the error complain that the SqlConnection, MyCmd, MyConn were undefined.

And you have a declaration of MyCmd ? You have the MyConn in the Web.Config correct? And what version of SQL DB are you using? Here is something to note:

"
The SQL Server .NET Data Provider allows you to connect to a Microsoft SQL Server 7.0 or 2000 database. For Microsoft SQL Server 6.5 or earlier, use the OLE DB .NET Data Provider with the "SQL Server OLE DB Provider" (SQLOLEDB).

Note: The SQL Server .NET Data Provider knows which data provider it is. Hence the "provider=" part of the connection string is not needed. "


I am working on the updated SQL version on the NEW THREAD soon.

But sometimes, and this is just Visual Studio's bug, if you copy and paste my code you may have to save and actually exit the application and then reload the ASP.Net Application in Visual Studio to have it see all the declarations you just pasted in. That should eliminate the squiggly lines under the underclared variables (and eliminate the messages associated with them).

If you are still having problems, Private Message me and I will try to solve them.

Happy Coding!