关键字“ d1”附近的语法不正确

debugcn 发表于 Dev

用户名

SQL查询可在SQL Server Management Studio中使用。但是，在Visual Studio中，它给出了一个错误

D1附近的语法不正确

代码：

private void GetDataByID(string _id)
{
    string connectionString = ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString;

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
         string sqlCommand = "SELECT  d1.*, d2.* FROM KFM.dbo.ToolBoxDocContent as d1, KFM.dbo.ToolBoxDocument as d2" +
               "where d1.DocumentId = d2.DocumentId and = d2.DocumentId =" + _id;

         SqlCommand cmd = new SqlCommand(sqlCommand, connection);
         SqlDataReader MyReader;

         try
         {
                connection.Open();
                MyReader = cmd.ExecuteReader();

                while (MyReader.Read())
                {
                    string sDueWeek = MyReader["DueWeek"].ToString();
                    string sTitle = MyReader["DocumentTitle"].ToString();
                    //string sEnglishBodyContent = MyReader["DocumentBody"].ToString();
                    //string sFrenchBodyContent = MyReader["DocumentBody"].ToString();
                    txb_Week.Text = sDueWeek;
                    txb_Title.Text = sTitle;
                }
         }
         catch (Exception ex)
         {
                Response.Write(ex.Message);
         }
     }
}

蜘蛛码

我在您的查询中注意到的一件事是

使用'+'进行两次联接之前，没有正确提供空格。之前使用空间where
atwhere子句的语法不正确。额外删除“=”后，and在and = d2.DocumentId = " + _id

您的最终查询如下所示：

string sqlCommand = "SELECT  d1.*, d2.* FROM KFM.dbo.ToolBoxDocContent as d1, KFM.dbo.ToolBoxDocument as d2" +
                   " where d1.DocumentId = d2.DocumentId and d2.DocumentId =" + _id;

更新：

string sqlCommand = "SELECT  d1.*, d2.* FROM KFM.dbo.ToolBoxDocContent as d1, KFM.dbo.ToolBoxDocument as d2" +
                   " where d1.DocumentId = d2.DocumentId and d2.DocumentId = '" + _id + "'";

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。