CSS messages Success ,Information, Warning ,Error

body{
font-family:Arial, Helvetica, sans-serif; 
font-size:13px;
}
.info, .success, .warning, .error, .validation {
border: 1px solid;
margin: 10px 0px;
padding:15px 10px 15px 50px;
background-repeat: no-repeat;
background-position: 10px center;
}
.info {
color: #00529B;
background-color: #BDE5F8;
background-image: url('info.png');
}
.success {
color: #4F8A10;
background-color: #DFF2BF;
background-image:url('success.png');
}
.warning {
color: #9F6000;
background-color: #FEEFB3;
background-image: url('warning.png');
}
.error {
color: #D8000C;
background-color: #FFBABA;
background-image: url('error.png');
}

<div class="info">Info message</div>
<div class="success">Successful operation message</div>
<div class="warning">Warning message</div>
<div class="error">Error message</div>

SQL SERVER Get columns of a table

SELECT column_name
FROM DATABASE_NAME.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'TABLE_NAME'

SQL Server search table in DataBase

select * from information_schema.tables where table_name like '%table_name%'

Preloader on Postback

1) Styles
    <style type="text/css">
        .LockOn {
            display: block;
            visibility: visible;
            position: absolute;
            z-index: 999;
            top: 0px;
            left: 0px;
            width: 100%;
            height: 100%;
            background-color: #fff;
            text-align: center;
            padding-top: 20%;
            filter: alpha(opacity=75);
            opacity: 0.75;
        }

        .PrProgress{
            width:300px;
            margin:0 auto;
        }
        .PrContainer{
            border: solid 1px #808080;
            border-width: 1px 0px;
        }
        .PrHeader{
            background: url(../img/sprite.png) repeat-x 0px 0px;
            border-color: #808080 #808080 #ccc;
            border-style: solid;
            border-width: 0px 1px 1px;
            padding: 0px 10px;
            color: #000000;
            font-size: 9pt;
            font-weight: bold;
            line-height: 1.9;
            white-space:nowrap;
            font-family: arial,helvetica,clean,sans-serif;
        }
        .PrBody{
            background-color: #f2f2f2;
            border-color: #808080;
            border-style: solid;
            border-width: 0px 1px;
            padding: 10px;
        }  
       
    </style>

2) Javascript
    <script type="text/javascript">
        function skm_LockScreen() {
            var lock = document.getElementById('skm_LockPane');
            if (lock)
                lock.className = 'LockOn';

        }
  </script>  

3) Div
       <div id="skm_LockPane" class="LockOff">
            <div class="PrProgress">
                <div id="innerPopup" class="PrContainer">
                    <div class="PrHeader">
                        Loading...
                    </div>
                    <div class="PrBody">
                        <img src="../images/preloader.gif" alt="Loading..." />
                    </div>          
                </div>
            </div>
        </div>

4) Button

    ID="btnSearch"  runat="server" Text="Search" OnClick="BtnSearch_Click"           OnClientClick="skm_LockScreen(); return true;" />

SQL SERVER - search text in stores procedures

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_DEFINITION LIKE '%text%' 
AND ROUTINE_TYPE='PROCEDURE'

SQL Server - Search in multiple tables - Buscar texto en varias tablas

CREATE PROC [dbo]. [spBuscarTexto]
(
@TextoBuscar nvarchar (100)
)
AS

BEGIN
CREATE TABLE #Resultado (NombreColumna nvarchar(370 ), ValorColumna nvarchar( 3630))

SET NOCOUNT ON

DECLARE @NombreTabla nvarchar( 256), @NombreColumna nvarchar (128), @TextoBuscar2 nvarchar(110 )
SET  @NombreTabla = ''
SET @TextoBuscar2 = QUOTENAME('%' + @TextoBuscar + '%', '''')

WHILE @NombreTabla IS NOT NULL

BEGIN
SET @NombreColumna = ''
SET @NombreTabla =
(
SELECT MIN (QUOTENAME( TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME ))
FROM INFORMATION_SCHEMA .TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND QUOTENAME (TABLE_SCHEMA) + '.' + QUOTENAME( TABLE_NAME) > @NombreTabla
AND OBJECTPROPERTY (
OBJECT_ID(
QUOTENAME(TABLE_SCHEMA ) + '.' + QUOTENAME (TABLE_NAME)
), 'IsMSShipped'
  ) = 0
)
WHILE (@NombreTabla IS NOT NULL) AND (@NombreColumna IS NOT NULL)

BEGIN
SET @NombreColumna =
(
SELECT MIN (QUOTENAME( COLUMN_NAME))
FROM INFORMATION_SCHEMA .COLUMNS
WHERE TABLE_SCHEMA = PARSENAME(@NombreTabla , 2)
AND TABLE_NAME = PARSENAME(@NombreTabla , 1)
AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar', 'uniqueidentifier')
AND QUOTENAME (COLUMN_NAME) > @NombreColumna
)

IF @NombreColumna IS NOT NULL

BEGIN
INSERT INTO #Resultado
EXEC
(
'SELECT ''' + @NombreTabla + '.' + @NombreColumna + ''', LEFT(' + @NombreColumna + ', 3630)
FROM ' + @NombreTabla + ' (NOLOCK) ' +
' WHERE ' + @NombreColumna + ' LIKE ' + @TextoBuscar2
)
END
END
END

SELECT NombreColumna , ValorColumna FROM #Resultado ORDER BY NombreColumna
END




[spBuscarTexto] 'texto buscado'

StreamReader Encoding: accents problem - problema con acentos

Use
System.Text.Encoding.Default

 StreamReader objReader = new StreamReader( file, System.Text.Encoding.Default, false);