110,539
社区成员
发帖
与我相关
我的任务
分享
private static bool IsHasValue(string selectstr)
{
SqlConnection conn = new Sql().CreateConnection();
conn.Open();
bool value = false;
SqlCommand cmd = new SqlCommand(selectstr, conn);
object obj = cmd.ExecuteScalar();
string s = obj.ToString();
if (obj.ToString() == "1")
value = true;
else
value = false;
conn.Close();
conn.Dispose();
cmd.Dispose();
return value;
}
private bool IsHasBooks(string selectstr)
{
SqlConnection conn = CreateConnection();
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = selectstr;
cmd.Connection = conn;
object result = cmd.ExecuteScalar();
conn.Close();
conn.Dispose();
cmd.Dispose();
bool value = false;
if (result == null)
return false;
else
return true;
}