default.aspx.cs

MS SQL数据库在线管理

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using SqlAdmin;

namespace SqlWebAdmin {
    /// <summary>
    /// Summary description for Login.
    /// </summary>
    public partial class Login : System.Web.UI.Page {


        public Login() {
            Page.Init += new System.EventHandler(Page_Init);
        }


        protected void Page_Load(object sender, System.EventArgs e) {

            if (ServerTextBox.Text != null && ServerTextBox.Text.Length == 0) {
                ServerTextBox.Text = "localhost";
            }

            ErrorLabel.Visible = false;
            LogoutInfoLabel.Visible = false;
            LoginInfoLabel.Visible = false;

            if (Request["error"] != null) {
                switch (Request["error"]) {
                    case "sessionexpired":
                        ErrorLabel.Text = "Your session has expired or you have already logged out. Please enter your login info again to reconnect.";
                        break;
                    case "userinfo":
                        ErrorLabel.Text = "Invalid username and/or password, or server does not exist.<br>Also, please ensure that SQL Server Authentication is enabled on the server.";
                        break;
                    default:
                        ErrorLabel.Text = "An unknown error occured.";
                        break;
                }
                ErrorLabel.Visible = true;
            }
            else if (Request["action"] == "logout") {
                LogoutInfoLabel.Visible = true;
            }
            else {
                LoginInfoLabel.Visible = true;
            }
        }

        protected void Page_Init(object sender, EventArgs e) {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
        }

        #region Web Form Designer generated code
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent() {    

        }
        #endregion

        protected void LoginButton_Click(object sender, System.EventArgs e) {
            if (!IsValid)
                return;

            SqlServer server = new SqlServer(ServerTextBox.Text, UsernameTextBox.Text, PasswordTextBox.Text);

            if (server.IsUserValid()) {
                // Create cookie and add session information to it
                HttpCookie cookie = new HttpCookie("WebDataAdministrator");
                cookie.Values.Add("username", server.Username);
                cookie.Values.Add("password", server.Password);
                cookie.Values.Add("server", server.Name);
                Response.Cookies.Add(cookie);

                Response.Redirect("databases.aspx");
            }
            else {
                ErrorLabel.Visible = true;
                ErrorLabel.Text = "Invalid username and/or password, or server does not exist.<br>Also, please ensure that SQL Server Authentication is enabled on the server.";
            }
        }
    }
}