可以在掌上电脑上使用存储过程. [英] 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屋！