One Click Computer Lock..

I know it seems interesting if somebody says we can lock your system with just a single click, so how to go about it. I have 2 options if you people have any other please let me know i will be glad to add this on the blog. ok about this the first method


you can either create a short cut on your desktop or write a simple command on your run command is


"%Windir%\system32\rundll32.exe user32.dll,LockWorkStation"

How about creating a short cut
1) Rightclick on your desktop you will see new >> Shortcut
2) on this window you need to type the command
"%Windir%\system32\rundll32.exe user32.dll,LockWorkStation"
click on next
3) type the desired name you like for this shortcut click on finish
4)click on this shortcut to test.


now comming on the simplest way the second way

i know this would be much much simpler than the previous one

Use windows Key from Keybord with L

i.e. Win+L your desktop would be locked .......

Tips for creating a folder named con.

It seems really simple creating a folder in windows OS but hay try to create a folder right now but the twist is to create the folder with name CON try it were you successful i know if you are trting this with the help of GUI(graphical user interface) its really hard yes there is a bug in windows os if you are trying to create a folder named as CON you wont be successful.


So what can we do to create this folder we can create this folder in CUI(character User Interface) or using command prompt.
Try these steps :

1) click on start >> run
2) on run type CMD & click ok
3) you will see a black prompt window
3) type Mkdir \\.\c:\
4) to remove this directory you can type rmdir \\.c:\con

Difference between DML DDL DCL and TCL?

DML:

DML is abbreviation of Data manipulation Language. It is useed to work with the data of the tables.

Basic Statements: SELECT, UPDATE, INSERT, delete statements.

DateTime Functions

To get current date

SELECT GETDATE()

To get yesterday

SELECT DATEADD(d,-1,GETDATE())

Saving changes is not permitted in SQL 2008 Management Studio?

I recently started using SQL Server 2008, at first it was really nice, but then I started getting a weird error every time I tried modifying a table.

"Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created."

Row Data Bound Event and how to use it

Row Data Bound Event and how to use it :


Control Used :Grid View 
Event Under Grid View :onrowdatabound

Error 'System.Web.UI.WebControls.GridView' does not have a public property named 'SortedAscendingCellStyle'.

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. 

Parser Error Message: Type 'System.Web.UI.WebControls.GridView' does not have a public property named 'SortedAscendingCellStyle'.

Source Error: 

Line 91: <RowStyle BackColor="White" ForeColor="#003399" />
 Line 92: <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
 Line 93: <SortedAscendingCellStyle BackColor="#EDF6F6" />
 Line 94: <SortedAscendingHeaderStyle BackColor="#0D4AC4" />
 Line 95: <SortedDescendingCellStyle BackColor="#D6DFDF" />