using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void loginOk_Click(object sender, EventArgs e)
{
SQLDMO.SQLServer SqlEXPRESS = new SQLDMO.SQLServerClass();
//组合SQLEXPRESS服务器名称
string sqlServer = txtSQL.Text.ToString();
string uid = txtUid.Text.ToString();
string pwd = txtPwd.Text.ToString();
try
{
SqlEXPRESS.Connect(sqlServer, uid, pwd);
Session["SqlServer"] = sqlServer;
Session["user"] = uid;
Session["password"] = pwd;
Response.Redirect("mainServer.aspx");
}
catch
{
Response.Write("服务器连接错误");
for (int i = 0; i < this.Controls.Count; i++)
{
this.Controls[i].Visible = false;
}
}
}
}
********************************************************************************************************
using System;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Data.SqlClient;
public partial class viewTableDetail : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string strSqlSer = Session["SqlServer"].ToString();
string strUid = Session["user"].ToString();
string strPwd = Session["password"].ToString();
string DbName = Request.QueryString.Get("requestDbName");
string TbName = Request.QueryString.Get("requestTbName");
txtDB.Text = DbName;
txtTB.Text = TbName;
string strConn = "data source=" + strSqlSer + ";user id=" + strUid + ";password=" + strPwd + ";initial catalog=" + DbName;
SqlConnection myConn = new SqlConnection(strConn);
string strSQL = "SELECT * FROM " + TbName;
SqlCommand myCommand = new SqlCommand(strSQL, myConn);
myConn.Open();
myGW.DataSource = myCommand.ExecuteReader();
myGW.DataBind();
myConn.Close();
}
protected void back_Click(object sender, EventArgs e)
{
Response.Redirect("mainServer.aspx");
}
}