感謝凌安的兄弟:雷穩學及苗建新提供

            '下傳至PC端
            Dim file As System.IO.FileInfo = New System.IO.FileInfo(strPath)
            Response.Clear()
            Response.AddHeader("Content-Disposition", "attachment; filename=" & strFileName)
            Response.AddHeader("Content-Length", file.Length.ToString())
            Response.ContentType = "application/octet-stream"
            Response.WriteFile(file.FullName)
            Response.End()

在找一些密碼的處理資料時,發現了這篇文章.算是利用ASP.Net特性來做密碼的處理.

我曾經看過幾個很好笑的密碼處理方式.以後就丟這份出去吧!

Web 應用程式安全性：安全的保護使用者密碼資訊

SELECT         sysobjects.name AS TABLE_NAME, sysindexes.name AS INDEX_NAME,
                          syscolumns.name AS COL_NAME, sysindexkeys.keyno
FROM             sysobjects INNER JOIN
                          sysindexes ON sysobjects.id = sysindexes.id INNER JOIN
                          sysindexkeys ON sysindexes.id = sysindexkeys.id AND
                          sysindexes.indid = sysindexkeys.indid INNER JOIN
                          syscolumns ON sysindexkeys.id = syscolumns.id AND
                          sysindexkeys.colid = syscolumns.colid INNER JOIN
                          sysobjects sysobjects_1 ON sysindexes.name = sysobjects_1.name
WHERE         (sysobjects.type = 'U')

資料來源:

http://episteme.arstechnica.com/eve/ubb.x/a/tpc/f/6330927813/m/6310944865

資料表清單:

SELECT sysobjects.id as id
 ,sysobjects.name as name
 ,sysusers.name as u_name
FROM sysobjects
left outer join sysusers on sysobjects.uid = sysusers.uid
WHERE sysobjects.xtype = 'U'
ORDER BY name

欄位清單:

select syscolumns.id as id
 ,syscolumns.name as name
 ,syscolumns.length as length
 ,syscolumns.isnullable as isnullable
 ,systypes.name as x_name
from syscolumns
left outer join systypes on syscolumns.xtype = systypes.xtype
where syscolumns.id = #search_id#
order by name