public static Boolean OperateData(string strsql)
{
try
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand(strsql, conn);
cmd.ExecuteScale();
conn.Close();
return true;
}
catch
{
//
return false;
}
}
//================登陆=========================================
public static bool CheckPerson(string sname, string sno)
{
string sql = "select count(*) from people where sname='" + sname + "' and sno='" + sno + "'";
OperateData(sql);
if (OperateData(sql))
{
return true;
}
else
{
return false;
}
//conn.Close();
}
这是App_code里面的Baseclass.cs文件一段代码 为什么连接数据库不起作用 随便什么都可以登录
用try catch实现的 需要加上什么代码或是什么才可以啊
{
try
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand(strsql, conn);
cmd.ExecuteScale();
conn.Close();
return true;
}
catch
{
//
return false;
}
}
//================登陆=========================================
public static bool CheckPerson(string sname, string sno)
{
string sql = "select count(*) from people where sname='" + sname + "' and sno='" + sno + "'";
OperateData(sql);
if (OperateData(sql))
{
return true;
}
else
{
return false;
}
//conn.Close();
}
这是App_code里面的Baseclass.cs文件一段代码 为什么连接数据库不起作用 随便什么都可以登录
用try catch实现的 需要加上什么代码或是什么才可以啊
public static bool OperateData(string strsql)
{
bool flag = false;
try
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand(strsql, conn);
int i = int.Parse(cmd.ExecuteScalar().ToString());
conn.Close();
if(i>0)
{
flag= true;
}
else
{
flag = false;
}
return flag;
}
catch(Exception ex)
{
}
} //================登陆=========================================
public static bool CheckPerson(string sname, string sno)
{
bool flag = false;
string sql = "select count(*) from people where sname='" + sname + "' and sno='" + sno + "'";
OperateData(sql);
if (OperateData(sql))
{
flag = true;
}
else
{
flag = false;
}
return flag;
}