how to use aspnet_db tables with my own db tables

Question

0.00/5 (No votes)

See more:

in my test system web application
i have added aspnet_db registration role memebership etc tables into my database.
and made three roles
1. admin
2. teacher (creat test function he will do)
3. student

now if i want to check which administrator or teacher work did (made test or added subjects details) then i need to add user ID into my all table ?? or any thing else i need to do?

Posted 6-Sep-13 18:12pm

Muhamad Faizan Khan

Updated 6-Sep-13 18:35pm

v2

Add a Solution

Comments

saad_lah 7-Sep-13 0:26am

plz clarify your question

Muhamad Faizan Khan 7-Sep-13 0:36am

ok

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

saad_lah · Answer 1 · 2013-09-06T18:46:00

Solution 1

AoA,

If you are making one table like roles in which you are handling students,teachers and administrators all, then you can do something like this

create table roles
(
-- user_id
-- user_name
-- user_role i.e say a label like "teacher,admin,student
-- add more things u want
)

and when you are using them in list or gridview, you can hide user_id in the tables
P.S : Jahan tak mujhe samajh ayi mein ne solution de diya... :P

Posted 6-Sep-13 18:46pm

saad_lah

Updated 6-Sep-13 18:50pm

v2

Comments

Muhamad Faizan Khan 7-Sep-13 2:12am

چلیں آپکو اردو میں سمجھا دیتا ہوں سعد بھائی رول ممبر شپ کے ٹیبل میں نے اپنے ڈیٹا بیس میں شامل کرلیے ہیں اب میں یہ دیکھنا چاہتا ہوں کے ٹیسٹ کس نے بنایا ڈیٹابیس میں، میرا مطلب کس ٹیچر نے بنا یا ہے تو کیا میں اپنے ٹیسٹ کے ٹیبل کے ساتھ یوزر آئی ڈی بھی شامل کرلو یا کوئی اور طریقہ بہتر ہوگا؟

saad_lah 7-Sep-13 2:30am

Make another table like test_creators

create table test
(
--user_id i.e teacher user_id
--course name
--test date
--add more thing if you want
)

ab jo bhi teacher koi new test bnaye ga...just add the teacher user_id and test date, test subject name in it....is se kitney tests create huwey hein aur kis teacher ne kiye hein

Muhamad Faizan Khan 7-Sep-13 2:37am

یوزر آئی ڈی جو ہوگی وہ اے ایس پی لاگن والی ہوگی نا؟

saad_lah 7-Sep-13 8:52am

yup, every person will be assigned a unique User_ID like in college or uni. RollNo is the identifier or unique id you can use seed or increment, takey automatically user_id increase hoti jaye....suppose 2000, next insertion mein 2001,2002 and so on,