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>
/// BaseClass 的摘要说明
/// </summary>
public class BaseClass
{
public BaseClass()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static SqlConnection DBCon()
{
return new SqlConnection("server=.;database=db_ExamOnline;uid=sa;pwd=;");
}
public static void BindDG(GridView dg, string id, string strSql, string Tname)
{
SqlConnection conn = DBCon();
SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);
DataSet ds = new DataSet();
sda.Fill(ds, Tname);
dg.DataSource = ds.Tables[Tname];
dg.DataKeyNames = new string[] { id };
dg.DataBind();
}
public static void OperateData(string strsql)
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand(strsql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
//================如果是学生登录=========================================
public static bool CheckStudent(string studentNum, string studentPwd)
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand("select count(*) from tb_Student where StudentNum='" + studentNum + "' and StudentPwd='" + studentPwd + "'", conn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
if (i > 0)
{
return true;
}
else
{
return false;
}
conn.Close();
}
//================如果是教师登录=========================================
public static bool CheckTeacher(string teacherNum, string teacherPwd)
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand("select count(*) from tb_Teacher where TeacherNum='" + teacherNum + "' and TeacherPwd='" + teacherPwd + "'", conn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
if (i > 0)
{
return true;
}
else
{
return false;
}
conn.Close();
}
//================如果是管理员登录=========================================
public static bool CheckAdmin(string adminNum, string adminPwd)
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand("select count(*) from tb_Admin where AdminNum='" + adminNum + "' and adminPwd='" + adminPwd + "'", conn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
if (i > 0)
{
return true;
}
else
{
return false;
}
conn.Close();
}
}点击登录后提示sa用户登录失败!我的数据库名为:z705-35\SQLEXPRESS 用户名:sa 密码:123
提示页面如下
“/ExamOnLine”应用程序中的服务器错误。
--------------------------------------------------------------------------------用户 'sa' 登录失败。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 用户 'sa' 登录失败。源错误:
行 81: {
行 82: SqlConnection conn = DBCon();
行 83: conn.Open();
行 84: SqlCommand cmd = new SqlCommand("select count(*) from tb_Admin where AdminNum='" + adminNum + "' and adminPwd='" + adminPwd + "'", conn);
行 85: int i = Convert.ToInt32(cmd.ExecuteScalar());
源文件: d:\新建文件夹\在线考试系统参考案例源程序\09\ExamOnLine\App_Code\BaseClass.cs 行: 83 堆栈跟踪:
[SqlException (0x80131904): 用户 'sa' 登录失败。]
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>
/// BaseClass 的摘要说明
/// </summary>
public class BaseClass
{
public BaseClass()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static SqlConnection DBCon()
{
return new SqlConnection("server=.;database=db_ExamOnline;uid=sa;pwd=;");
}
public static void BindDG(GridView dg, string id, string strSql, string Tname)
{
SqlConnection conn = DBCon();
SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);
DataSet ds = new DataSet();
sda.Fill(ds, Tname);
dg.DataSource = ds.Tables[Tname];
dg.DataKeyNames = new string[] { id };
dg.DataBind();
}
public static void OperateData(string strsql)
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand(strsql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
//================如果是学生登录=========================================
public static bool CheckStudent(string studentNum, string studentPwd)
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand("select count(*) from tb_Student where StudentNum='" + studentNum + "' and StudentPwd='" + studentPwd + "'", conn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
if (i > 0)
{
return true;
}
else
{
return false;
}
conn.Close();
}
//================如果是教师登录=========================================
public static bool CheckTeacher(string teacherNum, string teacherPwd)
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand("select count(*) from tb_Teacher where TeacherNum='" + teacherNum + "' and TeacherPwd='" + teacherPwd + "'", conn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
if (i > 0)
{
return true;
}
else
{
return false;
}
conn.Close();
}
//================如果是管理员登录=========================================
public static bool CheckAdmin(string adminNum, string adminPwd)
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand("select count(*) from tb_Admin where AdminNum='" + adminNum + "' and adminPwd='" + adminPwd + "'", conn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
if (i > 0)
{
return true;
}
else
{
return false;
}
conn.Close();
}
}点击登录后提示sa用户登录失败!我的数据库名为:z705-35\SQLEXPRESS 用户名:sa 密码:123
提示页面如下
“/ExamOnLine”应用程序中的服务器错误。
--------------------------------------------------------------------------------用户 'sa' 登录失败。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 用户 'sa' 登录失败。源错误:
行 81: {
行 82: SqlConnection conn = DBCon();
行 83: conn.Open();
行 84: SqlCommand cmd = new SqlCommand("select count(*) from tb_Admin where AdminNum='" + adminNum + "' and adminPwd='" + adminPwd + "'", conn);
行 85: int i = Convert.ToInt32(cmd.ExecuteScalar());
源文件: d:\新建文件夹\在线考试系统参考案例源程序\09\ExamOnLine\App_Code\BaseClass.cs 行: 83 堆栈跟踪:
[SqlException (0x80131904): 用户 'sa' 登录失败。]
解决方案 »
- ASP.NET 关于Repeate的一个奇怪的问题,希望高手帮忙,谢谢!
- 有关AJAX
- 分页问题
- 高分求助:关于LOGIN登陆控件用法
- C#操作word的问题
- 希望大家积极的讨论下"SQL Server 不存在或访问被拒绝"问题(也可以加群12866156进行讨论)
- 动态添加的dropdownlist的SelectedIndexChanged不执行
- 如何判断链接是否有效???
- datagrid问题 请你帮忙
- 谷歌下,js获取<input type="file" ... />绝对路径失败,被修改成C:\fakepath\...形式
- 单例之后,要控制里面的方法的访问顺序要怎么做= =
- net怎么实现根据ip获取所在您当前所在的位置
我的数据库名为:z705-35\SQLEXPRESS 用户名:sa 密码:123 ????
你觉得一致么?同学
我修改过还是不对,
所以我发的是老师发的代码,
我把整个程序发给你,
大家帮我看下,
我们实训,
问老师老师是不说的,
谢谢大家了。。
为这个问题已经耗费我一上午了
QQ295811976