我一直收到错误System.Data.SQLite.SQLiteException：'SQL logic error near "into"：语法错误‘
我一直收到错误System.Data.SQLite.SQLiteException：'SQL logic error near "into"：语法错误‘
提问于 2019-10-16 17:11:58
我找不出代码enter image description here出了什么问题
System.Data.SQLite.SQLiteException：‘“into”附近的SQL逻辑错误:语法错误’
private void BtnUpdate_Click(object sender, EventArgs e)
{
string StudentIDq = "update into Student (StudentID, ExamBoard, Firstname, Surname, Pure, Statistics, Mechanics, Total, " + "Average, Rank) values ('" + txtStudentID.Text + ", " + cmbExamBoard + ", " + txtFirstname.Text + "," + "" + txtSurname.Text + "," + txtPure.Text + ", " + txtStats.Text + "," + txtMechanics.Text + " + " + txtTS.Text + "," + txtAvrg.Text + "," + txtRank.Text + ")";
ExecuteQuery(StudentIDq);
LoadData();
}回答 2
Stack Overflow用户
发布于 2019-10-16 17:16:23
private void BtnUpdate_Click(object sender, EventArgs e)
{
string StudentIDq = "insert into Student (StudentID, ExamBoard, Firstname, Surname, Pure, Statistics, Mechanics, Total, " + "Average, Rank) values ('" + txtStudentID.Text + ", " + cmbExamBoard + ", " + txtFirstname.Text + "," + "" + txtSurname.Text + "," + txtPure.Text + ", " + txtStats.Text + "," + txtMechanics.Text + " + " + txtTS.Text + "," + txtAvrg.Text + "," + txtRank.Text + ")";
ExecuteQuery(StudentIDq);
LoadData();
}Stack Overflow用户
发布于 2019-10-16 19:35:38
如果要更新列，则查询将如下所示
string StudentIDq = "update Student set StudentID=" + txtStudentID.Text + ", ExamBoard= " + cmbExamBoard + ", Firstname='" + txtFirstname.Text + "', Surname='" + txtSurname.Text + "', Pure='" + txtPure.Text + "', Statistics='" + txtStats.Text + "', Mechanics='" + txtMechanics.Text + "' , Total=" + txtTS.Text + ", " + "Average=" + txtAvrg.Text + ", Rank=" + txtRank.Text + ") ;还要添加Where条件，否则所有列都将更新
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/58409765
复制相关文章
相似问题
腾讯云开发者
