可以在掌上电脑上使用存储过程. [英] It is possible to use stored procedure on a pocket pc.
本文介绍了可以在掌上电脑上使用存储过程.的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
可以在掌上电脑上使用存储过程.我没有找到任何有关此的信息.如果是,我在哪里可以找到有关此文件的文档.
这是我在c#中的代码:
It is possible to use stored procedure on a pocket pc. I did not find any information about that. If yes where can I found documentation on that.
This is my code in c#:
SqlCeConnection SqlCnx = new SqlCeConnection(GlobalVar.strConnexion);
try
{
SqlCeCommand myCommand = new SqlCeCommand("getAuction", SqlCnx);
myCommand.CommandType = CommandType.StoredProcedure;
SqlCeDataAdapter dataAdapterInfoAuctList = new SqlCeDataAdapter(myCommand);
dataAdapterInfoAuctList.Fill(dataSetInfosalvage, "auct");
dataTableAuct = dataSetInfosalvage.Tables["auct"];
dtgridAuction.DataSource = dataTableAuct;
}
catch (SqlCeException Ex)
{
MessageBox.Show("Error 0002 :\n" + Ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
}
finally
{
SqlCnx.Dispose();
}
但这给了我一个错误:
CommandType枚举值1无效.
我需要帮助.
But that give me an error :
The CommandType enumeration value, 1, is invalid.
I need help.
推荐答案
否. SqlCE不支持存储过程.
考虑一下:它是一个单用户数据库,不需要存储过程(根据Microsoft的说法).
No. SqlCE does not support stored procedures.
Think about it: it is a single user database, it doesn''t need stored procedures (gospel according to Microsoft).
这篇关于可以在掌上电脑上使用存储过程.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文