public static string ToBase64(this string src, Encoding encoding) { byte[] b = encoding.GetBytes(src); return Convert.ToBase64String(b); } public static string Base64ToString(this string src, Encoding encoding) { byte[] b = Convert.FromBase64String(src); return encoding.GetString(b); }
Thứ Hai, 27 tháng 10, 2014
Base64 Encode/Decode C#
Nhãn:
.NET Framework
,
ASP.NET
,
C#
,
Cryptography
Remove Html Tag, Html Encode/Decode, Url Encode/Decode
Thỉnh thoảng cần dùng, lưu lại cho nhớ.
public static string RemoveHtml(this string text) { return Regex.Replace(text, "<[^>]*>", string.Empty); } public static string HtmlEncode(this string src) { return System.Net.WebUtility.HtmlEncode(src); } public static string HtmlDecode(this string src) { return System.Net.WebUtility.HtmlDecode(src); } public static string UrlEncode(this string src) { return System.Web.HttpUtility.UrlEncode(src); } public static string UrlDecode(this string src) { return System.Web.HttpUtility.UrlDecode(src); }
Thứ Ba, 14 tháng 10, 2014
Set a Database to Single-user Mode
Using SQL Server Management Studio
To set a database to single-user mode
- In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
- Right-click the database to change, and then click Properties.
- In the Database Properties dialog box, click the Options page.
- From the Restrict Access option, select Single.
- If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections, click Yes.
You can also set the database to Multiple or Restricted access by using this procedure. For more information about the Restrict Access options, see Database Properties (Options Page).
Using Transact-SQL
To set a database to single-user mode
- Connect to the Database Engine.
- From the Standard bar, click New Query.
- Copy and paste the following example into the query window and click Execute. This example sets the database to SINGLE_USER mode to obtain exclusive access. The example then sets the state of the AdventureWorks2012 database to READ_ONLY and returns access to the database to all users.The termination option WITH ROLLBACK IMMEDIATE is specified in the first ALTER DATABASE statement. This will cause all incomplete transactions to be rolled back and any other connections to the AdventureWorks2012 database to be immediately disconnected.
USE master; GO ALTER DATABASE AdventureWorks2012 SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO ALTER DATABASE AdventureWorks2012 SET READ_ONLY; GO ALTER DATABASE AdventureWorks2012 SET MULTI_USER; GO
http://msdn.microsoft.com/en-us/library/ms345598.aspx
Thứ Tư, 8 tháng 10, 2014
Đăng ký:
Bài đăng
(
Atom
)