مشكل با Incorrect syntax near the keyword 'WHERE'.
سلام
ميشه لطف كنيد ببينيد اشكال كد من تو كجاست؟؟؟؟؟؟؟؟؟؟؟
تو خطي كه ستاره گذاشتم اين پيغام رو بهم ميده هر كاري كردم برطرف نشد
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();
جواب بصورت نقل قول
