c# - 我的 Access 数据库不更新 (ASP.NET)

Question

我想我在连接到我的数据库时遇到了问题，因为它没有按预期更新。我不确定这是为什么。这是我的 .aspx.cs 文件:

public partial class addClass : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    private static OleDbConnection GetConnection()
    {
        String connection;
        connection = @"connectionstring";

        return new OleDbConnection(connection);

    }
    string one = "one";
    protected void submitButton_Click(object sender, EventArgs e)
    {
        OleDbConnection myConnection = GetConnection();


        try
        {

            myConnection.Open();
            String myQuery = "INSERT INTO Yoga Class([ClassName], [Level], [Duration], [Capacity], [Description]) values ('" +
                classNameTextBox.Text + "','" + levelDropDownList.SelectedItem.Text + "','" + durationDropDownList.SelectedItem.Text + "','" + capacityDropDownList.SelectedItem.Text +
                "','" + descriptionTextBox.Text + "');";

            String myQuery2 = "INSERT INTO YogaTeacher([TeacherID]) values('" +one+ "');";


            OleDbCommand myCommand = new OleDbCommand(myQuery, myConnection); //get rid of parameters 



            myCommand.ExecuteNonQuery();

            myConnection.Close();
        }

        catch
        {
            Response.Write("Form did not submit due to an error");
        }

        finally
        {
            myConnection.Close();
        }
    }



   }
}

我认为它没有更新的原因是因为表“Yoga Class”中的列 teacherID 是另一个表中的外键。单击提交按钮时会显示“catch”语句中的错误消息。我对么？我该如何更改我的代码以使其正常工作？

感谢任何帮助

谢谢

Answer 1

您的代码:String Query = "INSERT INTO Yaga 课...表名“Yoga Class”中不应有空格。