trick folder GodFolder

GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}
Paste this name folder :) Enjoy
Read More

How to make SQL Backup All DataBases

DECLARE @Baksql VARCHAR(8000)
DECLARE @BackupFolder VARCHAR(100)
DECLARE @BackupFile VARCHAR(100)
DECLARE @BAK_PATH VARCHAR(4000)
DEclare @BackupDate varchar(100)
-- Setting value of  backup date and folder of the backup
SET @BackupDate =  REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR,GETDATE(),120),'-',''),':',''),' ','_') -- 20110517_182551
SET @BackupFolder = 'C:\Backups\'
SET @Baksql = ''
-- Declaring cursor
DECLARE c_bakup CURSOR FAST_FORWARD READ_ONLY FOR 
SELECT NAME FROM SYS.DATABASES
WHERE state_desc = 'ONLINE' -- Consider databases which are online
AND database_id > 4  -- Exluding system databases

-- Opening and fetching next values from sursor
OPEN c_bakup
FETCH NEXT FROM c_bakup INTO @BackupFile
WHILE @@FETCH_STATUS = 0
BEGIN
SET @BAK_PATH = @BackupFolder + @BackupFile
-- Creating dynamic script for every databases backup
SET @Baksql = 'BACKUP DATABASE ['+@BackupFile+'] TO DISK = '''+@BAK_PATH+'_FullBackup_'+@BackupDate+'.bak'' WITH INIT;'
-- Executing dynamic query
PRINT (@Baksql)
EXEC(@Baksql)
-- Opening and fetching next values from sursor
FETCH NEXT FROM c_bakup INTO @BackupFile
END
-- Closing and Deallocating cursor
CLOSE c_bakup
DEALLOCATE c_bakup
Read More

Field GridView with Link with Parameter

<asp:HyperLinkField Text="&lt;img src='../Img/view.png' alt='alternate text' border='0'/&gt;"
                    DataNavigateUrlFields="Id"  DataNavigateUrlFormatString="PAGE.aspx?Id={0}"
                    HeaderImageUrl="../Img/view.png" >
                <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:HyperLinkField>
Read More

Object Data Source Select Parameter

<SelectParameters>
 <asp:ControlParameter ControlID="field" DbType="String" DefaultValue="1" Direction="Input" Name="ParameterName"  PropertyName="Text" />
</SelectParameters>
Read More

DataGridView COL with Image

<asp:TemplateField>
 <ItemTemplate>
  <asp:Image ID="Image1" Height="32px" runat="server" ImageUrl='<%# String.Format("{0}{1}{2}", "PATH", Eval("FIELD"),".jpg") %>' />
 </ItemTemplate>
 <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</asp:TemplateField>
Read More

Convert short

Convert.ToInt16(field)


Read More

How to view Server Variables

foreach (string x in Request.ServerVariables)
{
Response.Write(x + ": " + Request.ServerVariables[x] + "<br>");
}
Read More

NTLM - ASPX C#

Properties project

Servers

click checkbox -> NTLM authentication

web.config

<authentication mode="Windows">
</authentication>

IIS

Authentication -> windows authentication -> Enable
Authentication -> windows authentication -> Providers -> put NTLM first 
Read More