Tuesday, January 12, 2016
When to insert a lot of data sql 2005 mobile Unknown error
About 600 data ("insert into ..."), with a circulation insert statement as follows:
// Execute SQL statements
static public void ExecuteNoQuery (string queryString)
{
SqlCeCommand queryCmd = new SqlCeCommand (queryString, conn);
queryCmd.ExecuteNonQuery ();
}
When the execution to more than 500 of the abnormal, but the pop-up error message is empty, do not support SQL Mobile is not so much data? I got on the phone to run on the normal data will be inserted in the PC.
Reply:
555555555 ...
Reply:
In Manin teacher's "SQL Server 2005 SqlCeResultSet and high-performance data access Depth" to do a Demo test, the greater the amount of data.
Reply:
Bangding
SQL Mobile also have to ask the question:
Because I was using a database on Smartphone, so I installed the C: \ Program Files \ Microsoft Visual Studio 8 \ SmartDevices \ SDK \ SQL Server \ Mobile \ v3.0 \ wce500 \ armv4i directory of
sqlce30.dev.ENU.phone.wce5.armv4i.CAB
sqlce30.phone.wce5.armv4i.CAB
sqlce30.repl.phone.wce5.armv4i.CAB
Three CAB, written procedures and operation of the database table no problem, but I want to verify the database table is not what I want, not by what I wrote a program to see, I think things through Query Analyzer, a similar look, I do not know The install anything and now I find .sdf through the file browser, I want to open it, an error message appears: say there is associated with the file of the application, how to do it can be viewed on PC sdf also OK it! ! Jiya !!!!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment