Himalaya
سه شنبه 04 مرداد 1390, 18:30 عصر
سلام.
بعد از اینکه Connection String تو web.config قرار گرفت
<div>
<asp:Label ID="lblMess" runat="server" Text=""></asp:Label>
<br /><br />
<asp:Button ID="BtnProtect" runat="server" Text="Protect" onclick="BtnProtect_Click" />
<asp:Button ID="BtnUnProtect" runat="server" Text="UnProtect" onclick="BtnUnProtect_Click" />
<asp:Button ID="BtnShowConnectionString" runat="server" Text="ShowConnectionString" onclick="BtnShowConnectionString_Click" />
</div>
protected void BtnProtect_Click(object sender, EventArgs e)
{
Configuration config = WebConfigurationManager.OpenWebConfiguration(Reque st.ApplicationPath);
ConfigurationSection section = config.GetSection("connectionStrings");
if (!section.SectionInformation.IsProtected)
{
section.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
config.Save();
lblMess.Text = "Success Protect. Please review connection string section in web.config";
}
else
lblMess.Text = "connectionStrings section was Protected.";
}
protected void BtnUnProtect_Click(object sender, EventArgs e)
{
Configuration config = WebConfigurationManager.OpenWebConfiguration(Reque st.ApplicationPath);
ConfigurationSection section = config.GetSection("connectionStrings");
if (section.SectionInformation.IsProtected)
{
section.SectionInformation.UnprotectSection();
config.Save();
lblMess.Text = "Success Unprotect. Please review connection string section in web.config";
}
else
lblMess.Text = "connectionStrings section was not protected.";
}
protected void BtnShowConnectionString_Click(object sender, EventArgs e)
{
lblMess.Text = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
}
کانکشن استرینگ بعد از کد شدن توسط دکمه BtnProtect
<connectionStrings configProtectionProvider="DataProtectionConfigurationProvider">
<EncryptedData>
<CipherData>
<CipherValue>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAih2a6ehRxUWM5mFkvc1nmwQAAAACAAAAAAAQZgAAA AEAACAAAABSACgAitYZIfCLM3Y44iP/3xyo3ArrlRh7UXEPep33xQAAAAAOgAAAAAIAACAAAABimucOCc KjISHVZ86fDvJNqqnaiQPjjFYOQyoTnF4y1aABAABby2EKERrh AMua4dYpuDkEovP/6Ew6GJVITz2Ee+Ai0GLArr826XNNcrM6vIyCMqJpDit7y6mwxV GVMCvj2cyOFIo8AQRNGY/fHXHe3/aSXrfSlzYmEwyXKvE6iOqCU0RK0CDXAcxnfvEvYO4k971RmBmj YEKhJr6+lAvMYwwR/vUt/YN1Lc1NMU49rq67po4/d9aLilzFAlvhA62V8pVviOVo9u/hWgraVLAKBC/JIAk6r6no9HycSWEAwlRwTlAFFfHRsPMddls17tjUQD5DhW2sQ o/v1HpCbAZ3JsmdCiKh2m9OtizgnOC0tPC6v/+99KOe+sfnIibvZHLpJAjqGKTgZY45yKflDmNgt6REYpK1/vqDMfuAoo4UIg/I8buF2dnQmmcm3bXYZchv6cnYHi35vmRMbmvsGlioMegPxMZ/z2DJYBpSKoa8IuKsYdNU1Xab+J4ETPSS8R83HZyma3eCBFbP1K mPGUKdg0K/PT3u8C2BRAwYPG44unT+TjZ83wZ1RLLtS+PmZMU6uPr3mAkjC4 XnDL2mrxRhXaG4hUAAAABVvCeLTfqrakHEEnM8pkmV88OcWCW7 5KcSbjq8q3JP3yvkiw8/ojip8xIaEBmS4bARZkgi9V3dRhHZwP7nvTsl</CipherValue>
</CipherData>
</EncryptedData>
</connectionStrings>
که تو هر دو حالت کد شده و نشده، واسه خوندن کانکشن استرینگ، مثل قبل عمل میکنیم. (BtnShowConnectionString)
از طریق خط فرمان هم میتونی کانکشن استرینگ رو کد کنی، واسه دستورش هم تو گوگل بسرچ