捕捉到 System.Data.SqlServerCe.SqlCeException
Message="分析查询时出错。 [ Token line number = 1,Token line offset = 148,Token in error = ) ]"
Source="SQL Server Compact ADO.NET Data Provider"
HResult=-2147217900
NativeError=25501//---------------下面是引发异常的方法:public void AddEmptyData(short testtype, string tfname)
{
SqlCeCommand sccmd = new SqlCeCommand();
sccmd.Connection = new SqlCeConnection(Properties.Settings.Default.HelpDatabaseConnectionString);
sccmd.CommandText = "insert into TestLibrary(tfname,testtype,test1,test2,test3,test4,test5,test6,test7,test8,test9) values(@tfname,@testtype,'','','','','','','','','',)";
sccmd.Parameters.Add("@tfname", SqlDbType.NVarChar, 100).Value = tfname;
sccmd.Parameters.Add("@testtype", SqlDbType.TinyInt).Value = testtype;
sccmd.Connection.Open();
sccmd.ExecuteNonQuery();
sccmd.Connection.Close();
this.Massage = "新行已经初始化.";
}
Message="分析查询时出错。 [ Token line number = 1,Token line offset = 148,Token in error = ) ]"
Source="SQL Server Compact ADO.NET Data Provider"
HResult=-2147217900
NativeError=25501//---------------下面是引发异常的方法:public void AddEmptyData(short testtype, string tfname)
{
SqlCeCommand sccmd = new SqlCeCommand();
sccmd.Connection = new SqlCeConnection(Properties.Settings.Default.HelpDatabaseConnectionString);
sccmd.CommandText = "insert into TestLibrary(tfname,testtype,test1,test2,test3,test4,test5,test6,test7,test8,test9) values(@tfname,@testtype,'','','','','','','','','',)";
sccmd.Parameters.Add("@tfname", SqlDbType.NVarChar, 100).Value = tfname;
sccmd.Parameters.Add("@testtype", SqlDbType.TinyInt).Value = testtype;
sccmd.Connection.Open();
sccmd.ExecuteNonQuery();
sccmd.Connection.Close();
this.Massage = "新行已经初始化.";
}
//最后面多了一逗号
sccmd.CommandText = "insert into TestLibrary(tfname,testtype,test1,test2,test3,test4,test5,test6,test7,test8,test9) values(@tfname,@testtype,'','','','','','','','','')";