简单的ACCESS查询分析器

来源：互联网发布：在流放地知乎编辑：程序博客网时间：2024/06/05 02:40

只要你的机器上有.net framework 1.1 和 IIS,然后你做个ASPX页面并拷贝到任意虚拟目录下就可以了：
<%@ Page LANGUAGE="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <%@ Import Namespace="System.Web " %> <%@ Import Namespace="System.Web.UI.WebControls" %> <%@ Import Namespace="System.Web.UI.HtmlControls" %> <%@ Import Namespace="System "%> <%@ Import Namespace="System.Collections "%> <%@ Import Namespace="System.ComponentModel "%> <%@ Import Namespace="System.Drawing "%> <%@ Import Namespace="System.Web.UI "%> <%@ Import Namespace="System.Web.SessionState "%> <html> <HEAD> <title>exesql</title> <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1"> <meta name="CODE_LANGUAGE" Content="C#"> <meta name="vs_defaultClientScript" content="JavaScript"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> <style> .TextBox { WIDTH: 90% } .TextArea { WIDTH: 90%; HEIGHT: 200px } </style> </HEAD> <body> <form id="Form1" method="post" runat="server"> <TABLE id="Table1" cellSpacing="0" cellPadding="0" width="100%" border="0" o> <TR id="history"> <TD style="WIDTH:150px" valign="top"><input style="border:solid 1px black;" type="button" value="View History" onclick="var tempC = document.getElementById('Label_History');if(tempC.style.display != 'none') {tempC.style.display = 'none';this.value='view history!'} else {tempC.style.display = '';this.value='hide history!'}"><input style="border:solid 1px black;" type="button" value="Clear History" onclick="document.getElementById('Label_History').innerHTML = '';document.getElementById('isClearHistory').value='clear';document.getElementById('Label_History').style.display='none';"><input type="hidden" value="" name="history" id="isClearHistory"></TD> <TD><div id="Label_History" runat="server" style="color:blue;display:none;"></div> </TD> </TR> <TR> <TD> connection string: </TD> <TD> <asp:TextBox CssClass="TextBox" id="TextBox_ConnStr" runat="server"></asp:TextBox></TD> </TR> <TR> <TD valign="top"> sql string : </TD> <TD> <asp:TextBox CssClass="TextArea" id="TextBox_SqlStr" runat="server" TextMode="MultiLine"></asp:TextBox></TD> </TR> <TR> <TD></TD> <TD> <asp:Button id="Button_Execute" runat="server" Text="Execute"></asp:Button></TD> </TR> <TR> <TD colspan="2"> <asp:Label id="Label_Message" runat="server" ForeColor="Red"></asp:Label></TD> </TR> <TR> <TD colSpan="2"> <asp:Panel id="Panel_Result" runat="server"></asp:Panel></TD> </TR> </TABLE> </form> </body> </html>