sngapoonage

Hi everyone, I want to implement an "achievement" system of sorts into one of my projects. Similar to StackOverflow where if you do a certain thing or answer a certain number of questions etc you get a trophy that is linked with your user profile. The membership section of my …

Hi everyone, I'm having a bit of trouble figuring out what to do here. Basically I have 3 tables shown below User Table [CODE] ID Firstname Lastname etc.... 1 James Hay 2 Someone Else [/CODE] Permissions Table [CODE] PermissionID UserID 1 1 2 1 2 2 3 2 [/CODE] Permissions …

Hi everyone, I have a stored procedure which takes 2 integer parameters and returns either a 1 or a 0. It's quite long so I won't post it here unless you feel it's nessesary. Currently I have a table named 'Books', a table named 'Filters'. Each row in 'Books' has …

Hi everyone, I use the ADO.Net SqlConnection, SqlCommand and SqlDataReader for all of my database interaction within my DAL. When I do a SELECT statement I cycle through my reader in a while loop and store each row in custom objects I have created. It seems to me like nobody …

Hi everyone, Here is my situation: I have a table of users in my database with all the usual user information it it. I have another table which lists the rights that each user has. this table has 2 columns 'Userid','Functionid'. Each user may have multiple rows in this table, …

Hi everyone, I am building a database of users for our website. It is an MSSQL database. Currently I have all the usual fields eg First Name, Last Name, email etc. There are different things that our users need to have access to on our site. At the current time …