Stored procedure with mobile application

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();
                }

But that gice me an error :

The CommandType enumeration value, 1, is invalid.

I need help
MacloskyAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
MacloskyAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.