<%@ Import NameSpace="System"%>
<%@ Import NameSpace="System.Data"%>
<%@ Import NameSpace="System.Data.SqlClient"%>
<%@ Import NameSpace="System.Web"%>
<%@ Import NameSpace="System.Web.SessionState"%>
<%@ Import NameSpace="System.Web.UI"%>
<%@ Import NameSpace="System.Web.UI.HtmlControls"%>
<%@ Import NameSpace="System.Web.UI.WebControls"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>教务实验课系统</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">
<script language="C#" runat="server">
public void checkUser(object sender, System.EventArgs e)
{
string strType=null;
strType=drpType.SelectedValue.ToString();
SqlConnection conn;;
SqlCommand comm=new SqlCommand();
if(strType=="学生")
{
conn=new SqlConnection();
conn.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["DSN_student"];
comm.CommandText="select * from student_login where s_id='"+ txtXh.Text.ToString()+" and sl_pwd='"+txtPwd.Text.ToString();
}
else
{
conn=new SqlConnection();
conn.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["DSN_teacher"];
comm.CommandText="select * from teacher_login where t_id='"+txtXh.Text.ToString()+" and tl_pwd='"+txtPwd.Text.ToString();
}
try
{
conn.Open();
SqlDataReader dr=comm.ExecuteReader();
if(dr.Read())
{
//通过验证
if((Request.Cookies["userInfo"]==null))
{
HttpCookie cookie=new HttpCookie("userInfo");
cookie.Values.Add("userID",this.txtXh.Text.ToString());
cookie.Values.Add("userIdent",this.drpType.SelectedValue.ToString());
Response.AppendCookie(cookie);
}
else
{
HttpCookie cookie=new HttpCookie("userInfo");
cookie.Values.Add("userID",this.txtXh.Text.ToString());
cookie.Values.Add("userIdent",this.drpType.SelectedValue.ToString());
Response.AppendCookie(cookie); }
Server.Transfer("../student/index.aspx");
}
}
catch
{
//抛出异常
lblErr.Text="与服务器连接失败!";
}
finally
{
conn.Close();
conn=null;
}
}与数据库交互后总会出现"与服务器连接失败!",郁闷,想确认一下这里面代码到底有没有错,请高手指点一二!
<%@ Import NameSpace="System.Data"%>
<%@ Import NameSpace="System.Data.SqlClient"%>
<%@ Import NameSpace="System.Web"%>
<%@ Import NameSpace="System.Web.SessionState"%>
<%@ Import NameSpace="System.Web.UI"%>
<%@ Import NameSpace="System.Web.UI.HtmlControls"%>
<%@ Import NameSpace="System.Web.UI.WebControls"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>教务实验课系统</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">
<script language="C#" runat="server">
public void checkUser(object sender, System.EventArgs e)
{
string strType=null;
strType=drpType.SelectedValue.ToString();
SqlConnection conn;;
SqlCommand comm=new SqlCommand();
if(strType=="学生")
{
conn=new SqlConnection();
conn.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["DSN_student"];
comm.CommandText="select * from student_login where s_id='"+ txtXh.Text.ToString()+" and sl_pwd='"+txtPwd.Text.ToString();
}
else
{
conn=new SqlConnection();
conn.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["DSN_teacher"];
comm.CommandText="select * from teacher_login where t_id='"+txtXh.Text.ToString()+" and tl_pwd='"+txtPwd.Text.ToString();
}
try
{
conn.Open();
SqlDataReader dr=comm.ExecuteReader();
if(dr.Read())
{
//通过验证
if((Request.Cookies["userInfo"]==null))
{
HttpCookie cookie=new HttpCookie("userInfo");
cookie.Values.Add("userID",this.txtXh.Text.ToString());
cookie.Values.Add("userIdent",this.drpType.SelectedValue.ToString());
Response.AppendCookie(cookie);
}
else
{
HttpCookie cookie=new HttpCookie("userInfo");
cookie.Values.Add("userID",this.txtXh.Text.ToString());
cookie.Values.Add("userIdent",this.drpType.SelectedValue.ToString());
Response.AppendCookie(cookie); }
Server.Transfer("../student/index.aspx");
}
}
catch
{
//抛出异常
lblErr.Text="与服务器连接失败!";
}
finally
{
conn.Close();
conn=null;
}
}与数据库交互后总会出现"与服务器连接失败!",郁闷,想确认一下这里面代码到底有没有错,请高手指点一二!
解决方案 »
- 未能加载文件或程序集“System.Core, Version=3.5.0.0, Culture=neutral,
- MVC url路径问题
- GridView主键问题
- 测试ASP登录问题
- 急!关于下载代码的,50M以下没问题,今天测试了160M的发现无法解析文件
- 类型转化错误,恳求路过朋友解决,谢谢!
- 请问:SQL Server Management Studio Express如何导入/导出数据?
- detailspage.aspx?id={0}" 如何生成detailspage.aspx?id={0}这个页面这个页面该怎么写.
- 求asp.net在线视频播放的一个实例
- 抢分啦!!
- 那位老大能给指点一下!
- 各位牛人,在C#中的一个函数中调用前台的Javascript要怎么用
<%@ Page language="c#" Codebehind="Login.aspx.cs" AutoEventWireup="false" Inherits="OhmyOh.WebForm1" %>