我有一个页面,在本地很正常,上传到服务器上就报 “不能使用 '';文件已在使用中。”数据库是ACCESS由于1、本地是正常的
2、这是第一个用到数据库的页面,之前没有打开数据库的操作
所以 我觉得不是打开数据库conn.open而未关闭conn.close的原因那到底是什么原因呢??? 求解! 会不会是数据库权限的问题????我是菜鸟不精通这个,万分感谢啦我只有22分,20分已经是倾家荡产了,请别嫌弃少代码奉上:
<!--管理信息界面登录-->
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %><%@ Page language="C#" Debug="true" %><script language="c#" runat="server">
private void Page_Load(object sender,EventArgs e)
{
OleDbConnection conn = null;
OleDbCommand cmd = null;
OleDbDataReader reader = null;
conn = new OleDbConnection(Application["conn"].ToString());
conn.Open(); ---此处报错 String StrUsername = txtUsername.Text;
String StrPassword = txtPassword.Text;
String strSQL="SELECT USERNAME,PASSWORD FROM t_admin WHERE USERNAME='" + StrUsername + "' AND PASSWORD ='" + StrPassword + "'"; cmd = new OleDbCommand(strSQL, conn);
reader = cmd.ExecuteReader(); if ( StrUsername != "" )
{
if (!reader.Read())
{
Response.Write("<SCRIPT LANGUAGE='JavaScript'>window.alert('用户名密码不正确。');<"+"/script>");
}
else
{
Session["username"] = txtUsername.Text;
Session["password"] = txtPassword.Text;
Response.Redirect("/manage/index_eneage_mqur_condition.aspx");
}
}
conn.Close();
} private void btnAddEneage_Click(object sender, System.EventArgs e)
{
}
</script>
2、这是第一个用到数据库的页面,之前没有打开数据库的操作
所以 我觉得不是打开数据库conn.open而未关闭conn.close的原因那到底是什么原因呢??? 求解! 会不会是数据库权限的问题????我是菜鸟不精通这个,万分感谢啦我只有22分,20分已经是倾家荡产了,请别嫌弃少代码奉上:
<!--管理信息界面登录-->
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %><%@ Page language="C#" Debug="true" %><script language="c#" runat="server">
private void Page_Load(object sender,EventArgs e)
{
OleDbConnection conn = null;
OleDbCommand cmd = null;
OleDbDataReader reader = null;
conn = new OleDbConnection(Application["conn"].ToString());
conn.Open(); ---此处报错 String StrUsername = txtUsername.Text;
String StrPassword = txtPassword.Text;
String strSQL="SELECT USERNAME,PASSWORD FROM t_admin WHERE USERNAME='" + StrUsername + "' AND PASSWORD ='" + StrPassword + "'"; cmd = new OleDbCommand(strSQL, conn);
reader = cmd.ExecuteReader(); if ( StrUsername != "" )
{
if (!reader.Read())
{
Response.Write("<SCRIPT LANGUAGE='JavaScript'>window.alert('用户名密码不正确。');<"+"/script>");
}
else
{
Session["username"] = txtUsername.Text;
Session["password"] = txtPassword.Text;
Response.Redirect("/manage/index_eneage_mqur_condition.aspx");
}
}
conn.Close();
} private void btnAddEneage_Click(object sender, System.EventArgs e)
{
}
</script>
关了也会报错,不过我发现好像是打开这个页面Response.Redirect("/manage/index_eneage_mqur_condition.aspx");
的缘故
我把这句注掉虽然不跳转了,但是也不会报错了
<%@ Page language="C#" Debug="true" %>
<%@ Import Namespace="System.Globalization" %>
<%@ Import Namespace="System.Web.UI" %>
<%@ Import Namespace="System.Web.UI.WebControls" %>
<%@ Import Namespace="System.Web.UI.HtmlControls" %><!--#include file="../inc/conn.aspx"--><%
if(Session["username"] == null)
{
Response.Write("<Script Language='JavaScript'>window.opener=null;window.close();</Script>");
}
%><script language="c#" runat="server">
private void sum_Click(object sender, System.EventArgs e)
{
String strPara = "";
strPara = "/manage/index_eneage_mqur.aspx?";
strPara += "NAME=" + txtSelname.Text;
strPara += "&JOB=" + selJob.SelectedItem.Value;
strPara += "&SEX=" + selSex.SelectedItem.Value;
strPara += "&LEARN=" + selLearn.SelectedItem.Value;
strPara += "&APPRAISE=" + selAppraise.SelectedItem.Value;
strPara += "&PERSON=" + txtPerson.Text;
strPara += "&ORIGIN=" + selOrigin.SelectedItem.Value; Response.Redirect(strPara); }
</script><!--#include file="../inc/close_conn.aspx"-->