標籤：
在啟明星的示範網站裡，經常有使用者修改示範密碼，導致別的使用者無法訪問。
為此，在登陸頁面，增加了一個“初始化資料庫”功能，這樣，即使使用者修改了密碼，別的訪問者，只要重設資料庫，就可以很容易再次進入。
首先，利用MSSQL Manage Studio生產指令碼放到網站下。
下面是SQL.aspx原始碼
<%@ Page Language="C#" AutoEventWireup="true" %><%@ Import Namespace="System" %><%@ Import Namespace="System.Data.SqlClient" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Web.Configuration" %><%@ Import Namespace="System.IO" %><%@ Import Namespace="System.Text" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><script runat="server"> protected void btnInitDb_Click(object sender, EventArgs e) { string connectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString; string DBName = "book.sql"; //try //{ // this.Response.Write("Write connecting string to web.config<BR>"); // Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath); // string csName = "connectionstring"; // ConnectionStringsSection csSection = config.ConnectionStrings; // csSection.ConnectionStrings[csName].ConnectionString = connectionString; // config.Save(ConfigurationSaveMode.Modified); //} //catch (Exception ex) //{ // Response.Write("寫入web.config資料錯誤：" + ex.ToString()); // return; //} SqlConnection conn = null; try { using (StreamReader sr = new StreamReader(Server.MapPath("~/app_data/"+DBName))) { // Create new connection to database conn = new SqlConnection(connectionString); conn.Open(); while (!sr.EndOfStream) { StringBuilder sb = new StringBuilder(); SqlCommand cmd = conn.CreateCommand(); while (!sr.EndOfStream) { string s = sr.ReadLine(); if (s != null && s.ToUpper().Trim().Equals("GO")) { break; } sb.AppendLine(s); } // Execute T-SQL against the target database cmd.CommandText = sb.ToString(); cmd.CommandTimeout = 3000; cmd.ExecuteNonQuery(); } } Response.Redirect("default.aspx"); // Page.RegisterClientScriptBlock("success", "<script>alert(‘安裝成功，系統自動跳轉到首頁‘); window.location=‘../default.aspx‘; </script> "); } catch (Exception ex) { this.Response.Write(String.Format("An error occured: {0}", ex.ToString())); return; } finally { if (conn != null) { try { conn.Close(); conn.Dispose(); } catch (Exception ee) { this.Response.Write(String.Format(@"Could not close the connection. Error was {0}", ee.ToString())); } } } }</script><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title>資料庫工具</title></head><body> <form id="form1" runat="server"> <div> 初始化資料庫將把系統還原為原始狀態，初始化後即可用admin登陸. </div> <asp:Button ID="btnInitDb" runat="server" onclick="btnInitDb_Click" Text="初始化資料庫" /> </form></body></html>
注意紅色部分，如果你使用，請修改為你自己的資料庫資訊。
這樣，就再也不擔心使用者隨便修改資料庫賬戶了
你也可以單擊此處下載原始碼 http://files.cnblogs.com/files/mqingqing123/SQL.rar
利用ASP.NET運行資料庫的安裝指令碼
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
