html - How to have a unique page for each user ASP.NET C# -
i have in site table , want each user empty table can edit himself , displayed him when logs in.
for each user same table diffrent values belong him , can edit it.
the edit , table work fine problem users see same table same values.
instead of creating sessions. can create user row in userprofile table of database, save values.
then when he's logged in, utilize userid, create dynamic url like
www.example.com/userid/1234
stack overflow uses same thing. utilize id , show info related own id. utilize database store info of profile , on.
the thing differ between table , info utilize condition. in sql known where
clause, , in coding known if (condition == value) { }
. utilize status seperate values, this
var db = database.open("database_name"); var sqlquery = "select * table userid =@0"; var result = db.query(sqlquery, websecurity.currentuserid);
this homecoming columns related user logged in. can loop through result this
foreach (var row in result) { // create table here! }
http://www.asp.net/web-pages/tutorials/data/5-working-with-data
c# html asp.net visual-studio session
No comments:
Post a Comment