ASP.NET WEB.CONFIGÃô¸ÐÐÅÏ¢¼ÓÃÜѧϰ
½ñÌ죬¿´µ½PETSHOP4.0ÀïµÄWEB.CONFIG¶ÔÊý¾Ý¿âÁ¬½Ó×Ö·û´®¼ÓÃÜ£¬ËùÒÔÌØÒâѧϰ²¢¼Ç¼ÏÂÀ´¡£
.net ÌṩÁË System.Configuration.RsaProtectedConfigurationProvider ¡£
Ê×ÏÈÅäÖÃWEB.CONFIG
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<configProtectedData>
<providers>
<clear />
<add name="KeyProvider" type="System.Configuration.RsaProtectedConfigurationProvider, System.Configuration, Version=2.0.0.0,Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL" keyContainerName="Key" useMachineContainer="true" />
</providers>
</configProtectedData>
<connectionStrings>
<add name="SQL_Northwind" connectionString="Data Source=localhost;Initial Catalog=Northwind;User ID=sa;Password=sa;" />
</connectionStrings>
</configuration>
asp.net ÌṩÁËÃüÁîÐеķ½Ê½£¬¶ÔÆä¼ÓÃÜ£¬ÕâÀïÎÒҲûÓоßÌåʵÀý£¬¾Í²»½²À²¡£
ÎÒ»¹Êǰ´ÕÕ³ÌÐòµÄ·½Ê½£¬Ð½¨Ò»¸öÒ³Ãæ
Ö´ÐÐÏÂÃæµÄ·½·¨£º
Configuration config = WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
ConfigurationSection section = config.GetSection("connectionStrings");
if (section != null && !section.SectionInformation.IsProtected)
{
section.SectionInformation.ProtectSection("KeyProvider");
config.Save();
}
·½·¨Ö´Ðкó£¬WEB.CONFIG ÎļþÓ¦¸ÃÓÐÀàËÆÒÔϵĴúÂë³öÏÖ£º
<connectionStrings configProtectionProvider="KeyProvider">
<EncryptedData Type="http://www.w3.org/2001/04/xmlenc#Element"
xmlns="http://www.w3.org/2001/04/xmlenc#">
<EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#tripledes-cbc" />
<KeyInfo xmlns="http://www.w3.org/2000/09/xmldsig#">
<Encrypt
Ïà¹ØÎĵµ£º
//private string datapatch = ConfigurationSettings.AppSettings["acessconn"];//Êý¾Ý¿âµØÖ·
private string datapatch = "db/global.asa";//Êý¾Ý¿âµØÖ·
///
/// È¡µÃdataset
//
/// ²éѯÓï¾ä
///
public DataSet GetDataSet(string Commandtext)
{&nbs ......
¸ßЧʹÓÃʹÓÃSQL»º´æÒÀÀµ
ASP.NET FrameworkÐÂÔöµÄÒ»¸ö·Ç³£Ç¿´óµÄ¹¦ÄÜÊÇSQL»º´æÒÀÀµ¡£¸Ã¹¦ÄÜÔÊÐíµ×²ãÊý¾Ý¿âÖеÄÊý¾ÝÐÞ¸Äʱ£¬×Ô¶¯µØÖØÐÂÔØÈ뻺´æµÄÊý¾Ý¡£
ÔÚʹÓþø¶Ô»º´æ¹ýÆÚ²ßÂÔ»òÕßµ¯ÐÔ»º´æ¹ýÆÚ²ßÂÔʱÓÐÒ»¸öȨºâ£¬¶ÔÓÚÐÔÄܺͳ¾ÉÊý¾ÝµÄȨºâ¡£ÀýÈ磬Èç¹ûÔÚÄÚ´æÖлº´æÊý¾Ý20Ã룬ÔòÕâ20ÃëÄÚÏÔʾµÄÊý¾Ý¿ÉÄÜÊǹ ......
ÔÌûµØÖ·£ºhttp://www.wangchao.net.cn/bbsdetail_572426.html
¼ò½é
¡¡¡¡ÓÐÐí¶à´ÏÃ÷µÄ°ì·¨¿ÉÒÔ½â¾öHTTPÐÒéµÄÎÞ״̬ÎÊÌ⣬ÀýÈç¶Ôÿ¸öÇëÇóÖØ¸´·¢ËÍÓ¦ÓóÌÐòÊý¾Ý°ü¡¢Ê¹ÓÃHTTPÈÏÖ¤»úÖÆÀ´½«ÇëÇóÓ³Éäµ½ÌØ¶¨µÄÓû§¡¢Ê¹ÓÃCookieÀ´´æ´¢Ò»ÏµÁÐÇëÇóµÄ״̬µÈ¡£ÔÚASP.net¼¼ÊõÖÐÌṩÁË ......
ʹÓÃDataRelationÀà´´½¨¹ØÏµ²¢ÀûÓø¸/×Ó¹ØÏµ¶ÁÈ¡Êý¾ÝʾÀý
void Page_Load(object sender, System.EventArgs e)
{
// Á¬½Ó×Ö·û´®ºÍ SQL Óï¾ä
string ConnString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
......
¹ØÓÚEXCELµÄ±¨±íµ¼³ö£¬¿¼Âǵ½µ¼³öºÄʱµÄÎÊÌâÎÒÖ÷Òª²ÉÓÃAJAXÀ´×öµÄ£¬·Ö±ð²¶×½¼¸¸öÆðֹ״̬£¬¸ø¿Í»§¶ËÌáʾ3¸ö״̬£ºÕýÔÚ¼ìË÷Êý¾Ý¡£¡£¡£---¡·×¼±¸µ¼³öÊý¾Ý¡£¡£¡£(Ö»ÊÇ´ÓÊý¾Ý¿â³É¹¦È¡³ö£¬»¹Ã»ÓжÁдexcelÎļþ)--¡·ÕýÔÚ¶ÁдÎļþ--¡·µ¼³öÊý¾Ý³É¹¦£¬µ±È»Èç¹ûÄÄÒ»¹ý³Ì³ö´í£¬¶¼ÓжÔÓ¦µÄÌáʾ£¬Ö»ËùÒÔÏ뵽дÕâÆªÎÄÕ£¬Ö÷ÒªÊÇÒòΪ ......