private double GetTotakMoney(string type)
{
//SELECT SUM(ConsumnuMoney) AS Expr1 FROM consnu WHERE (Type = '支出')
double total=0;
string sql = "SELECT SUM(ConsumnuMoney) AS Expr1 FROM consnu WHERE (Type = '支出')";
//SqlCommand cmd = new SqlCommand(sql, DbHelper.myConn);
OleDbCommand cmd = new OleDbCommand(sql, DbHelper.myConn);
DbHelper.myConn.Open();
object obj = cmd.ExecuteScalar();
//Object obj = cmd.ExecuteScalar();
if (obj.ToString() != "")
{
total = Convert.ToDouble(obj);
}
DbHelper.myConn.Close();
return total;
}
string sql = "SELECT SUM(ConsumnuMoney) AS Expr1 FROM consnu WHERE (Type = '支出')";
SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。
我查不到什么保留字啊
{
//SELECT SUM(ConsumnuMoney) AS Expr1 FROM consnu WHERE (Type = '支出')
double total=0;
string sql = "SELECT SUM(ConsumnuMoney) AS Expr1 FROM consnu WHERE (Type = '支出')";
//SqlCommand cmd = new SqlCommand(sql, DbHelper.myConn);
OleDbCommand cmd = new OleDbCommand(sql, DbHelper.myConn);
DbHelper.myConn.Open();
object obj = cmd.ExecuteScalar();
//Object obj = cmd.ExecuteScalar();
if (obj.ToString() != "")
{
total = Convert.ToDouble(obj);
}
DbHelper.myConn.Close();
return total;
}
string sql = "SELECT SUM(ConsumnuMoney) AS Expr1 FROM consnu WHERE (Type = '支出')";
SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。
我查不到什么保留字啊
下面这个没问题了
SELECT SUM(ConsumnuMoney) AS Expr1 FROM consnu WHERE (Type = '支出')