mahan206
چهارشنبه 27 اسفند 1393, 09:50 صبح
سلام من یه سایت دارم کلا خوب کار میکرد بعد یوهو با این مشکل مواجه شدم بعد از یک ماه روی هاست بودن.
مشکل تو این قسمت امار سایته که این کدشه
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
/// <summary>
/// Summary description for StateSite
/// </summary>
public class StateSite
{
private static bool CheckDate()
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrin gs["Database20pConnectionString"].ConnectionString);
string query = "Select * From StateSite Where Date='" + DateTime.Now.ToShortDateString() + "'";
SqlCommand com = new SqlCommand(query, connect);
connect.Open();
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
return true;
}
else
{
return false;
}
connect.Close();
}
public static void SeeSite()
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrin gs["Database20pConnectionString"].ConnectionString);
string query = "";
SqlCommand com = new SqlCommand();
com.Connection = connect;
if (CheckDate())
{
query = "Update StateSite Set See+=1 Where Date='" + DateTime.Now.ToShortDateString() + "'";
com.CommandText = query;
}
else
{
query = "Insert Into StateSite (See,Date) Values (@See,@Date)";
com.CommandText = query;
com.Parameters.AddWithValue("@See", 1);
com.Parameters.AddWithValue("@Date", DateTime.Now.ToShortDateString());
}
connect.Open();
com.ExecuteNonQuery();
connect.Close();
}
public static DataSet GetState()
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrin gs["Database20pConnectionString"].ConnectionString);
string query = "select sum(See) as[All] ,(select See from StateSite where Date='" + DateTime.Now.ToShortDateString() + "')as[Now]," +
"(select See from StateSite where Date='" + DateTime.Now.AddDays(-1).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.
مشکل تو این قسمت امار سایته که این کدشه
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
/// <summary>
/// Summary description for StateSite
/// </summary>
public class StateSite
{
private static bool CheckDate()
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrin gs["Database20pConnectionString"].ConnectionString);
string query = "Select * From StateSite Where Date='" + DateTime.Now.ToShortDateString() + "'";
SqlCommand com = new SqlCommand(query, connect);
connect.Open();
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
return true;
}
else
{
return false;
}
connect.Close();
}
public static void SeeSite()
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrin gs["Database20pConnectionString"].ConnectionString);
string query = "";
SqlCommand com = new SqlCommand();
com.Connection = connect;
if (CheckDate())
{
query = "Update StateSite Set See+=1 Where Date='" + DateTime.Now.ToShortDateString() + "'";
com.CommandText = query;
}
else
{
query = "Insert Into StateSite (See,Date) Values (@See,@Date)";
com.CommandText = query;
com.Parameters.AddWithValue("@See", 1);
com.Parameters.AddWithValue("@Date", DateTime.Now.ToShortDateString());
}
connect.Open();
com.ExecuteNonQuery();
connect.Close();
}
public static DataSet GetState()
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrin gs["Database20pConnectionString"].ConnectionString);
string query = "select sum(See) as[All] ,(select See from StateSite where Date='" + DateTime.Now.ToShortDateString() + "')as[Now]," +
"(select See from StateSite where Date='" + DateTime.Now.AddDays(-1).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.