重新建立一个数据库访问页面，访问没起作用，还是访问原来得库

taylermail 2008-07-11 10:45:33

a页面
<%@ page language="C#" autoeventwireup="true" inherits="admin_admlg2" CodeFile="default.aspx.cs" %>
<HTML><HEAD><TITLE>后台登陆</TITLE>
<META http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="img/admin.css" type=text/css rel=stylesheet>
<SCRIPT>
function login(){
if (document.form1.adminname.value==""){alert("请输入用户名！");document.form1.adminname.focus();return false}
if (document.form1.adminpass.value==""){alert("请输入密码！");document.form1.adminpass.focus();return false}
return true}
</SCRIPT>

</HEAD>
<BODY><BR><BR><BR>
<FORM id="FORM1" name=form1 onSubmit="return login()" runat="server" target="_top">
<TABLE class="3d" cellSpacing=0 cellPadding=0 rules=none width=300 align=center border=0>
<TR class="uptitle" height=22>
<TD><B> <IMG src="img/ie.gif" align=absMiddle width="16" height="16"> 后台登陆</B></TD></TR>
<TR class=bg>
<TD><IMG src="img/adminlogin.gif" align=absMiddle border=0 width="300" height="80"></TD></TR><TR>
<TD align=middle height=30>
用户名：<INPUT class=yecao style="WIDTH: 150px" name=adminname autocomplete="off" id="Text1" runat="server"></TD></TR>
<TR>
<TD align=middle height=30> 密码：<INPUT class=yecao style="WIDTH: 150px" type=password name=adminpass id="Password1" runat="server"></TD></TR>
<TR>
<TD align=middle height=35> <INPUT class=adminbutton type=submit value="登录" name=Submit id="Submit1" onserverclick="Submit1_ServerClick" runat="server"> <INPUT class=adminbutton type=reset value="清空" name=reset></TD></TR>
<tr>
<td align="middle" >
</td>
</tr>
<tr>
<td align="middle" height="35">
</td>
</tr>
</TABLE>
</FORM></BODY></HTML>
b页面
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 admin_admlg2 : System.Web.UI.Page
{
admin adm = new admin();
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Submit1_ServerClick(object sender, EventArgs e)
{
string[] temp = new string[2];
if (this.Text1.Value.Trim() != "")
{
temp = adm.登陆(this.Text1.Value.Trim(), this.Password1.Value.Trim());

if (temp[0] != null)
{
Session["用户id"] = temp[0];
Session["类别"] = temp[1];
Session["用户名"] = this.Text1.Value.Trim();
Response.Redirect("admin.aspx");

}
else { this.Response.Write("<script>alert('用户名或密码错误1!')</script>"); }

}
else { this.Response.Write("<script>alert('用户名或密码错误2!')</script>"); };
}

}
c页面
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;
using System.Data.SqlClient;
using System.Text;

/// <summary>
/// conn 的摘要说明
/// </summary>
public class conn : SqlDataSource
{
public conn()
{
//
// TODO: 在此处添加构造函数逻辑
//
ConnectionString = "Data Source=192.168.0.4;Initial Catalog=newcxgw;Persist Security Info=True;User ID=zhangjian;Password=cxgw";
DataSourceMode = System.Web.UI.WebControls.SqlDataSourceMode.DataReader;
}
}
d页面
using System;
using System.Data;
using System.Configuration;
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.SqlClient;
/// <summary>
/// admin 的摘要说明
/// </summary>
public class admin
{
conn conn = new conn();
static string 用户库名="user1";
static string 权限库名="right1";
public admin()
{
//
// TODO: 在此处添加构造函数逻辑
//
}

public string[] 登陆(string 用户名,string 密码){

conn.SelectCommand = "select * from ["+用户库名+"] where 用户名=@用户名 and 密码=@密码";
conn.SelectParameters.Add("用户名", 用户名);
conn.SelectParameters.Add("密码", 密码);
string[] temp = new string[2];
SqlDataReader dd = (SqlDataReader)conn.Select(DataSourceSelectArguments.Empty);
if (dd.HasRows)
{
dd.Read();
temp[0] = dd["id"].ToString();
temp[1] = dd["类别"].ToString();
}
dd.Close();
return temp;

}
}
他们之间无法建立连接,我该程序,想重新访问一个库,但始终还是访问原来的库

...全文