导致以下错误的原因:'，'附近语法不正确

本文关键字：不正确 语法 错误 | 更新日期: 2023-09-27 18:08:35

我试图将信息插入到sql express 2008数据库上的表中，当我尝试插入字段时，我得到错误"语法不正确"，"有人能向我解释我的代码中有什么导致这个问题吗?

protected void insertworkshop_Click(object sender, EventArgs e)
    {
        using (SqlConnection conn2 = new SqlConnection(@"Data Source=CIS489_3'WILDLIFE;Initial Catalog=WildLife_Education;Integrated Security=True;"))
        {

            SqlCommand CmdSql2 = new SqlCommand("INSERT INTO [tblWorkshop] ([WorkshopName], [WorkshopBeginingDate], [WorkshopEndingDate], [WorkshopLocation], [InstructorID])VALUES (@WorkshopName, @WorkshopBeginingDate, @WorkshopEndingDate, @WorkshopLocation, @InstructorID)", conn2);
            conn2.Open();
            CmdSql2.Parameters.AddWithValue("@WorkshopName", workshopinsertname.Text.ToString());
            CmdSql2.Parameters.AddWithValue("@WorkshopBeginingDate", workshopinsertstart.Text.ToString());
        CmdSql2.Parameters.AddWithValue("@[WorkshopEndingDate", workshopinsertend.Text.ToString());
        CmdSql2.Parameters.AddWithValue("@WorkshopLocation", workshopinsertlocation.Text.ToString());
        CmdSql2.Parameters.AddWithValue("@InstructorID", insertinstructorid.SelectedValue.ToString());

        CmdSql2.Connection = conn2;
        CmdSql2.ExecuteNonQuery();
        conn2.Close();
        UpdateInsertWorkshop.Update();
        this.addnewworkshop_ModalPopupExtender.Hide();
    }

导致以下错误的原因:'，'附近语法不正确

在您的代码中，在下一行有一个额外的[:

 CmdSql2.Parameters.AddWithValue("@[WorkshopEndingDate", workshopinsertend.Text.ToString());
应:

 CmdSql2.Parameters.AddWithValue("@WorkshopEndingDate", workshopinsertend.Text.ToString());
相关文章：