解析查询时出错。 [英] There was an error parsing the query.
本文介绍了解析查询时出错。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
解析查询时出错。 [令牌行号= 1,令牌行偏移= 9,令牌错误= Otazky]
当我尝试更新表Otazky时显示这个
系统;
使用 System.Collections.Generic;
使用 System.Linq;
使用 System.Text;
使用 System.Data.SqlServerCe;
使用 System.Data;
使用 System.Windows.Forms;
命名空间 hra
{
静态 class SQLFunctions
{
static private SqlCeConnection cecon = new SqlCeConnection( @ 数据来源= D:\blbosti\škola\bakalárskapráca\hra\\\\\\\\\\\\\\
static public void InsertOtazka( int _ID, string _Otazka, string _SOdp)
{
try
{
cecon.Open();
SqlCeCommand insert = new SqlCeCommand( INSERT INTO [Otazky](Otazka,SOdp,ID)VALUES(@ Otazka,@ SOP,@ ID),cecon);
insert.Parameters.AddWithValue( @ Otazka,_ Otazka);
insert.Parameters.AddWithValue( @ ID,_ ID);
insert.Parameters.AddWithValue( @ SOdp,_ SOdp);
insert.ExecuteNonQuery();
MessageBox.Show( Otazka ulozena!);
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.ToString() );
}
最后
{
cecon.Close();
}
}
静态 public void InsertZlaOdpoved( int _ID, string _NOdp, string _pom)
{
try
{
cecon.Open();
SqlCeCommand insert = new SqlCeCommand( @ UPDATE Otazky SET NOdp1 = @NOdp WHERE ID,如@ID,cecon);
insert.Parameters.AddWithValue( @ NOdp,_NOdp);
insert.Parameters.AddWithValue( @ ID,_ ID);
insert.ExecuteNonQuery();
MessageBox.Show( Zla odpoved ulozena!);
}
catch (SqlCeException ex)
{
MessageBox.Show(ex的ToString());
}
最后
{
cecon.Close();
}
}
}
}
解决方案
谢谢Kornfeld Eliyahu Peter
cecon.Open();
SqlCeCommand insert = new SqlCeCommand( UPDATE [Otazky] SET NOdp1 = @NOdp WHERE ID = @ID,cecon);
insert.Parameters.AddWithValue( @ NOdp,_NOdp);
insert.Parameters.AddWithValue( @ ID,_ ID);
insert.ExecuteNonQuery();
MessageBox.Show( Zla odpoved ulozena!);
Hey guys, I'm having this problem I can't figure out and I'm wondering if any of you could help?
There was an error parsing the query. [ Token line number = 1,Token line offset = 9,Token in error = Otazky ]
This shows up when I'm trying to update table "Otazky"
ing System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlServerCe;
using System.Data;
using System.Windows.Forms;
namespace hra
{
static class SQLFunctions
{
static private SqlCeConnection cecon = new SqlCeConnection(@"Data Source=D:\blbosti\škola\bakalárska práca\hra\hra\Data.sdf");
static public void InsertOtazka(int _ID, string _Otazka, string _SOdp)
{
try
{
cecon.Open();
SqlCeCommand insert = new SqlCeCommand("INSERT INTO [Otazky] (Otazka, SOdp, ID) VALUES(@Otazka, @SOdp, @ID)", cecon);
insert.Parameters.AddWithValue("@Otazka", _Otazka);
insert.Parameters.AddWithValue("@ID", _ID);
insert.Parameters.AddWithValue("@SOdp", _SOdp);
insert.ExecuteNonQuery();
MessageBox.Show("Otazka ulozena!");
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
cecon.Close();
}
}
static public void InsertZlaOdpoved(int _ID, string _NOdp, string _pom)
{
try
{
cecon.Open();
SqlCeCommand insert = new SqlCeCommand(@"UPDATE Otazky SET NOdp1 = @NOdp WHERE ID LIKE @ID", cecon);
insert.Parameters.AddWithValue("@NOdp", _NOdp);
insert.Parameters.AddWithValue("@ID", _ID);
insert.ExecuteNonQuery();
MessageBox.Show("Zla odpoved ulozena!");
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
cecon.Close();
}
}
}
}
解决方案
thank you Kornfeld Eliyahu Peter
cecon.Open(); SqlCeCommand insert = new SqlCeCommand("UPDATE [Otazky] SET NOdp1 = @NOdp WHERE ID = @ID", cecon); insert.Parameters.AddWithValue("@NOdp", _NOdp); insert.Parameters.AddWithValue("@ID", _ID); insert.ExecuteNonQuery(); MessageBox.Show("Zla odpoved ulozena!");
这篇关于解析查询时出错。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文