how to format datetime in gridview for minutes OR Date

FORMAT MINUTES
<asp:BoundField DataField="HoraAT" HeaderText="Hora" ReadOnly="True" SortExpression="HoraAT" DataFormatString="{0:hh}:{0:mm}" />


FORMAT DATE

<asp:BoundField DataField="CriatedOn" HeaderText="CriatedOn"  DataFormatString="{0:yyyy-MM-dd}"      SortExpression="CriatedOn" Visible="false"/>
Read More

Howe to make random top X rows sql

SELECT TOP [Number]  [Field] FROM [TableName]
ORDER BY NEWID()


Read More

How to convert DateTime to Hour / Minute / Second

SELECT
CONVERT(VARCHAR(8) , GETDATE() , 108) AS HourMinuteSecond,
CONVERT(VARCHAR(5) , GETDATE() , 108) AS HourMinute

Read More

How to make UPDATE SELECT

UPDATE [TableName]
SET [Field]= BB.[Field]
                  FROM [TableName] BB
                                        INNER JOIN [TableName] AA ON BB.[Field] = AA.Field
Read More

Javascript LOGON_USER

var WinNetwork = new ActiveXObject('WScript.Network');
document.getElementById('"+Logon.Id+"').value = WinNetwork.UserName;

Read More