reza69
دوشنبه 09 تیر 1393, 22:46 عصر
سلام
موقع اجرای این کد ارور میگیره.
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrin gs["con"].ConnectionString);
string query = "select sum(See) as[All] ,(select See from statesite where date like N'" +
DateTime.Now.Date.ToShortDateString() + "') as[Now] ,(select See from statesite where date like N'"
+ DateTime.Now.AddDays(-1).Date.ToShortDateString() + "') as[Last] From statesite";
SqlDataAdapter da = new SqlDataAdapter(query, connect);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
ارور
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
موقع اجرای این کد ارور میگیره.
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrin gs["con"].ConnectionString);
string query = "select sum(See) as[All] ,(select See from statesite where date like N'" +
DateTime.Now.Date.ToShortDateString() + "') as[Now] ,(select See from statesite where date like N'"
+ DateTime.Now.AddDays(-1).Date.ToShortDateString() + "') as[Last] From statesite";
SqlDataAdapter da = new SqlDataAdapter(query, connect);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
ارور
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.