標籤：style blog http io ar color os sp for
在給一個客戶做的系統上，因為要對資料庫進行查看，但之前都是用TeamView來串連到客戶的伺服器進行資料庫操作的但最近客戶那邊的TeamView好像更改過密碼導致我無法正常串連,而巧了客戶的網官因為有事沒有上班所以也法擷取新的密碼。因為業務原因急需查看資料庫,所以就寫了一個簡單的SQl命令並部署到客戶的伺服器來通過Web執行Sql命令將ConnectonString更改為自己的資料庫連接並儲存為**.aspx即可<!DOCTYPE html><html><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>exec mssql command-HTL</title></head><%@ Page Language="C#" enableViewState="true" %><%@ Import namespace="System" %><%@ Import namespace="System.Data" %><%@ Import namespace="System.Data.SqlClient" %><script runat="server"> protected void Button1_Click(object sender, EventArgs e) { if(txt_sql.Value.Length>0){ string _ConnectionString=System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]; if(string.IsNullOrEmpty(_ConnectionString)) { Response.Write("ConnectionString is null<br>"); Response.End(); } Response.Write("Sql Command:<br>"+txt_sql.Value); using (SqlConnection connection = new SqlConnection(_ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { try{ cmd.Connection = connection; cmd.CommandText = txt_sql.Value; cmd.Connection.Open(); // exec select if(txt_sql.Value.ToString().ToLower().Contains("select ")) { using(SqlDataAdapter sda=new SqlDataAdapter(cmd)) { DataTable dtable = new DataTable(); sda.Fill(dtable); GridView1.DataSource=dtable; GridView1.DataBind(); } } //exec update,insert,delete,other else cmd.ExecuteNonQuery(); Response.Write("<br>sql Command Success"); } catch (Exception e1) { Response.Write(e1.Message); } finally{ connection.Close(); } }//end using sqlcommand }//end using SqlConnection }//end if }//end Button1_Click</script><body> <center> <h1 style="color:red;">at before executing Sql command , please backup database </h1> </center> <form id="form1" runat="server"> <asp:GridView ID="GridView1" runat="server" ></asp:GridView><br> <textarea id="txt_sql" runat="server" style="width:80%;height:200px;"></textarea> <br> <asp:Button ID="btnAdd" runat="server" Text="Exec Sql" OnClick="Button1_Click" /> </form></body></html>
<locationpath="mssql.aspx"><system.web><authorization><allowusers=".\WWW_mssql"/><denyusers="*"/></authorization></system.web></location>如果任務完成請將該檔案刪除，防止出現安全問題 至於為何要在asp.net頁面中直接編寫C#代碼？主要是簡單，只是一個檔案而已不需要重新編譯Dll且不會對現有的系統有任何影響。 參考(如何在Asp.net頁面中直接編寫C#代碼 )：MSDN Asp.net 頁文法[email protected] Import MSDN ASP.NET 頁類概述MSDN ASP.NET 網頁文法概述MSDN System.Data.SqlClient 命名空間
Asp.net 在網頁編寫C#程式碼範例-- 一個簡單的web MsSql 命令執行環境
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
