Comments by Dipesh Wadhwa

Dipesh Wadhwa 21-Oct-13 0:56am View

Check the following links, this will help you in ATTACHING & DE-ATTACHING DATABASE FILE in SQL EXPRESS.
http://technet.microsoft.com/en-us/library/ms190209.aspx

http://technet.microsoft.com/en-us/library/ms165673%28v=sql.105%29.aspx

http://blogs.msdn.com/b/bethmassi/archive/2008/12/18/attaching-a-local-sql-express-database-using-sqlcmd.aspx

Dipesh Wadhwa 17-Oct-13 3:19am View

Scheduling remote PC's and shutting it down. And Even if user power off and restarts PC, Password screen must be pop up on top. And Disable Task Manager for security purpose.
Now-a-days this concepts are mostly used in Cyber-Cafe's. Try it out interesting one.

OR

Build a web project saying Online Library.
In that if user is Register, the user should be able to Download, Upload, View & Delete e-Books.
and if user is not register, the user should be able to view e-books only that too till some limit (say 5Pages per Book,etc)

Dipesh Wadhwa 16-Oct-13 6:36am View

Modify if Condition as follows

IF (select AccessWord from UserAccess where UserName=@username AND AccessWord=@password) = @Password

Dipesh Wadhwa 11-Oct-13 4:55am View

OOPS...!!! By Mistake.

Dipesh Wadhwa 11-Oct-13 4:54am View

Deleted

.

Dipesh Wadhwa 11-Oct-13 4:54am View

Just store your DATA in BINARY FORMAT and you are done.
And while retrieving binary data use Convert Function.

Example: To Encrypt:- insert into [TableName] values (Convert(Binary,'Text Here'))
To Decrypt:- select (varchar,[BinaryColumnName]) from [TableName]

Dipesh Wadhwa 11-Oct-13 4:38am View

Just store your DATA in BINARY FORMAT and you are done.
And while retrieving binary data use Convert Function.

Example:
To Encrypt:- insert into [TableName] values (Convert(Binary,'Text Here'))

To Decrypt:- select (varchar,[BinaryColumnName]) from [TableName]

Comments by Dipesh Wadhwa (Top 7 by date)