using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Data.SqlClient;
namespace background
{
public class logins
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["TZroomConnectionString"].ConnectionString);
/// <summary>
/// 管理员登陆验证
/// </summary>
/// <param name="name">管理员名字</param>
/// <param name="pass">管理员密码</param>
/// <returns></returns>
public bool admin(String name, String pass) {
String T_name = name;
String T_pass = pass;
String sql = "select * from administrator where administrator='" + T_name + "' and password='" + T_pass + "'";
SqlCommand cmd = new SqlCommand(sql,conn);
try
{
conn.Open();
SqlDataReader MyReader = cmd.ExecuteReader();
if (MyReader.Read())
{
return true;
}
else {
return false;
}
}
catch (Exception ex)
{
throw (ex);
}
finally {
conn.Close();
}
}
}
}
我可以进入登陆界面,但是就不可以再进去了就出现上面的问题了
求指点
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Data.SqlClient;
namespace background
{
public class logins
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["TZroomConnectionString"].ConnectionString);
/// <summary>
/// 管理员登陆验证
/// </summary>
/// <param name="name">管理员名字</param>
/// <param name="pass">管理员密码</param>
/// <returns></returns>
public bool admin(String name, String pass) {
String T_name = name;
String T_pass = pass;
String sql = "select * from administrator where administrator='" + T_name + "' and password='" + T_pass + "'";
SqlCommand cmd = new SqlCommand(sql,conn);
try
{
conn.Open();
SqlDataReader MyReader = cmd.ExecuteReader();
if (MyReader.Read())
{
return true;
}
else {
return false;
}
}
catch (Exception ex)
{
throw (ex);
}
finally {
conn.Close();
}
}
}
}
我可以进入登陆界面,但是就不可以再进去了就出现上面的问题了
求指点
打印出
ConfigurationManager.ConnectionStrings["TZroomConnectionString"].ConnectionString看是什么
<add name="TZroomConnectionString"
connectionString=" Data Source=localhost; Initial Catalog=jagtest;Persist Security Info=True; User ID=sa;Password=123 " providerName="System.Data.SqlClient" />