Its inside a user control, the protection level doesn't exist to find it. Unless of course he made it public. But, since he can't access it anyways, he didn't. Which is a good programming practice not to expose it.
1 line of code equals many bugs. So don't write any!!
I am working on an Asp.Net 2.0 / MSSQL 2005 web site with authentication.
My web site has two type of users: "students" and "professors". They are not related!
All users need to login. Students use the role "student" and professors use the role "professor".
The information for students is different from the information of professors.
I could put all students and professors in the same table and leave some fields blank.
My option was to create the following tables:
A) "Authentication" with the fields:
[UserId], [Password], [PasswordFormat], [MobilePIN], [Email], [PasswordQuestion],
[PasswordAnswer], [IsApproved], [CreateDate], [LastLoginID] and [UserRole].
B) "Students" with the field [StudentID] and all the information fields for students.
C) "Professors" with the field [ProfessorID] and all the information fields for professors.
My questions are:
1. Am I following the right approach by using these 3 tables?
2. Should I place all info from users (students, professors and authentication) in "Authentication" table?
3. Should I keep only two tables, "Students" and "Professors" and move the login information to each record in these tables?
4. If using the 3 tables how can I know the info for a user after it logins? I could use a foreign key in Authentication table but I have 2 tables: students and professors.
Anyway this is really confusing.
Can someone, please, give me some advice of how to create the tables and set this authentication?
Actually I am using 2 dynamic dropdownlist , and their values are comming from the Database.
Dropdownlist values are filling from Database
and Selection of 1st dropdownlist value(Selected) the values of 2nd dropdownlist needs to be filled, and the values are filling too.
But the problem is on Selection of 2nd Dropdownlist
1st and 2nd Dropdown list values are filling again as Page Refresh
The Selected value of 1st Dropdownlist is as it is remain
But the 2nd dropdownlist index is zero , Code is as follows
Dim dap As New SqlDataAdapter(cmdstr, ConnectionString)
Dim dset As New DataSet
If dset.Tables("User").Rows.Count <> 0 Then
For i = 0 To dset.Tables("User").Rows.Count - 1
(im using access database and c#)
In my database i have a number of users details stored. One of these fields is a Yes/No field which is used to determine if the user has an active account.
For editing purposes this info is displayed on screen in the admin section via the usual method of a datagrid. I need this 'Active' field to be represented ad a tick box, so admins can simply select or deselect users, to change their account between active and inactive.
However this field in the datagrid simply shows the words 'True' or 'false' to reprsent this field. Any ideas how to represent this with a tick box?
I have a 7 digit number '1234561' and coresponding rows related to it are there in the same table. when i select certain rows in my previous page and click getit it takes me to next page where the 7 digit number gets created increasing the value as '1234562' and coresponding textboxes where the details have to be entered is displayed.Then number and the details gets stored in the table .
The number is unique and sequential so i want it to be generated from the backend but dont know to deal with it.
i have a textbox(asp.net server control).i'm binding the date to this text from calendar (calendar.asp).
when the date is binded no event is firing.
i want to execute a methos load() which is in code behind every time when the date is binded to the textbox.
i have use Ondatabinding(),onTextchanged() but didnt get the result..
pls tell me how to handle this
I want to generate a 10 digit number .I am selecting some details from one page submit it takes to me next page where i have to enter details in the form before entering the details a 10 didgit number appears on the page (automatically) after entering the detail if click submit the details along with nummber should stores in the backend I dont know the proper approach for this generating and storing value(asp.net withC#)
You have to store this value in backend somewhere like a separate table and whenever you want to generate this number then get this value from this table and increase 1 and also update this table.
I hope this will helpful to you.
Last Visit: 31-Dec-99 19:00 Last Update: 4-Dec-16 0:45