مشاهده نسخه کامل
: shahinfarasystem
22-09-2007, 13:51
سلام
ميشه لطف كنيد ببينيد اشكال كد من تو كجاست؟؟؟؟؟؟؟؟؟؟؟
تو خطي كه ستاره گذاشتم اين پيغام رو بهم ميده هر كاري كردم برطرف نشد
Incorrect syntax near the keyword 'WHERE'.
کد:
string cn = "database=NewMobile;server=.//;integrated security=true;";
SqlConnection adde = new SqlConnection(cn);
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataSet objDataSet = new DataSet();
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection = adde;
objDataAdapter.SelectCommand.CommandText = string.Format("Select * From(select * From tbl_SellFactor WHERE (TYear>='{0}')And(TYear<='{1}')) WHERE (TMounth<'{2}') AND (TMounth>'{3}')", Year, Year2, Mounth, Mounth2);
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
adde.Open();
****** objDataAdapter.Fill(objDataSet, "tbl_SellFactor");
adde.Close();
ميشه لطف كنيد ببينيد اشكال كد من تو كجاست؟؟؟؟؟؟؟؟؟؟؟
تو خطي كه ستاره گذاشتم اين پيغام رو بهم ميده هر كاري كردم برطرف نشد
Incorrect syntax near the keyword 'WHERE'.
کد:
string cn = "database=NewMobile;server=.//;integrated security=true;";
SqlConnection adde = new SqlConnection(cn);
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataSet objDataSet = new DataSet();
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection = adde;
objDataAdapter.SelectCommand.CommandText = string.Format("Select * From(select * From tbl_SellFactor WHERE (TYear>='{0}')And(TYear<='{1}')) WHERE (TMounth<'{2}') AND (TMounth>'{3}')", Year, Year2, Mounth, Mounth2);
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
adde.Open();
****** objDataAdapter.Fill(objDataSet, "tbl_SellFactor");
adde.Close();