|
I have developed an application for Win Mobile 5.0 in Visual Studio 2008. My application involves an access of data from SQL server mobile database. My application can access the data from the database when deployed on the Win mobile 5.0 pocket pc emulator. Now i have created a CAB file of my project in Visual Studio 2008 and then deployed this CAB file on Windows Mobile 6.0 (I am using HTC P3450 handset). When i run my application on the Win mobile handset i cannot access the data from sql server mobile database. What is the reason? Do i have to copy the SQL server mobile database to the Win mobile?
When i deploy the application on the emulator i can see the database in Query Analyser 3.5. I then connect the database to the project through Query Analyser 3.5. I am using .Net CF 3.5 and hence i have installed its cab file on the handset. But i could not see the Query Analyser 3.5 on the handset. Please help.
Thanks in advance
|
|
|
|
|
Hi Deepali Khalkar,
If your are able to view your database then your application should be access the Database through application. I Hope your database path is some different location.
Let me know whats exception you are getting.
Pavan Pareta
|
|
|
|
|
We are getting the following error on handset
File/Assembly name 'System.data.SqlServerCe,version=3.5.0.0,Culture=Neutral,Public key token=3BE235DF1C8D2AD3',or one of its dependencies was not found.
Thank You
|
|
|
|
|
Hi,
Install the sqlce30.cab on your mobile.
may be it solve your problem.
Thanks
~Khatri Mitesh
khatrimitesh@hotmail.com
Bikaner (Rajasthan)
INDIA
|
|
|
|
|
SqlCeCommand cmd = new SqlCeCommand("select count(*) from diet where uname=@uname,day=@dy,month=@mnth,year=@yr", conn);
cmd.Connection = conn;
SqlCeParameter para = new SqlCeParameter();
para.ParameterName = "@uname"
para.Value = uname;
cmd.Parameters.Add(para);
SqlCeParameter para12 = new SqlCeParameter();
para12.ParameterName = "@dy"
para12.Value = dy1;
cmd.Parameters.Add(para12);
SqlCeParameter para13 = new SqlCeParameter();
para13.ParameterName = "@mnth";
para13.Value = mnth;
cmd.Parameters.Add(para13);
SqlCeParameter para4 = new SqlCeParameter();
para4.ParameterName = "@yr";
para4.Value = yer1;
cmd.Parameters.Add(para4);
count = System.Convert.ToInt32(cmd.ExecuteScalar().ToString());
I have tried this code but getting an exception- An error parsing the query.
How to pass multiple parameters to the query which counts the rows from a table?
Please help.
Thanks in advance.
|
|
|
|
|
Hi,
I develop a window mobile software using vb.net and web service. and i want to update my project from when new update is available on the web. how i update the my project.
please suggest.
Thanks
~Khatri Mitesh
khatrimitesh@hotmail.com
Bikaner (Rajasthan)
INDIA
|
|
|
|
|
Hi Mitesh,
what you want exactly let me know, do you want to update your application in side the mobile, when you are getting any new update in your application or in your methods.
you need to clear all these thing while posting your question that would be more convenient.
Pavan Pareta
|
|
|
|
|
Hi Pavan
Actually i develop a Wm 5.0 Application using vb.net and web service. and i also upload my .cab file and .exe file on the web. and i want to update my mobile application when the new version is available on the web. so how i update my application. please suggest.
Thanks
~Khatri Mitesh
khatrimitesh@hotmail.com
Bikaner (Rajasthan)
INDIA
|
|
|
|
|
Hi Khatri Mitesh,
In this case you have to make version system in your application when your application run check your own version with web service method, if the version is different then download your application and install it self.
see this link
1) Creating Self-Updating Applications With the .NET Compact Framework[^]
Hope that this may be help.
Pavan Pareta
|
|
|
|
|
Hello ,I am developing a product device where i am using wince 5.0 ,with the help of Microsoft file viewer ,i could open PPT succesfully .As i migrated to Wince 6.0 for further advanced features ,found there is no Microsoft file viewer .Hence, am using Third party viewer and with the help of it tried to access PPT where encountered an error says :--
Error :function @ ordinal 959 missing
!!! please check your sysgen variable !!!
where as ,i could succesfully access PDF ,DOC,and XLS files.
Could anyone help me on his aspect and ,please let me know ...wht can be done to access PPT i.e wch Sysgen variable to be added ASAP.
|
|
|
|
|
I am creating smart device application using .net compact frame work 2.0
Please update me for "How to get drive free space in smart device application".
modified on Wednesday, April 1, 2009 8:57 AM
|
|
|
|
|
Hi
You can use P/Invoke method GetDiskFreeSpaceEx() to do that, it's very useful.
See Below Link[^]
Hope this may be help.
Pavan Pareta
|
|
|
|
|
ok i will check it........
|
|
|
|
|
got an error with following code
Error: Can't find entry point
<DllImport("CoreDll.dll", EntryPoint:="GetDiskFreeSpaceExA")> _
Private Shared Function GetDiskFreeSpaceEx(ByVal lpDirectoryName As String, ByRef lpFreeBytesAvailableToCaller As Long, ByRef lpTotalNumberOfBytes As Long, ByRef lpTotalNumberOfFreeBytes As Long) As Long
End Function
Public Shared Function GetInfo(ByVal drive As String, ByRef available As Long, ByRef total As Long, ByRef free As Long) As Long
Return GetDiskFreeSpaceEx(drive, available, total, free)
End Function
Public Shared Function GetInfo(ByVal drive As String) As DriveInfoSystem
Dim result As Long, available As Long, total As Long, free As Long
result = GetDiskFreeSpaceEx(drive, available, total, free)
Return New DriveInfoSystem(drive, result, available, total, free)
End Function
please help me on this.
|
|
|
|
|
Hi all,
I am working with Visual Studio .Net 2005. I have created new Smart Device Project with MFC smart Device application. I have selected SDK application option. It should display the inbuilt menu, but the application is not displaying the menu. How to enable menu. please help.
|
|
|
|
|
Hi
Want to show popup notification for "low battery" in .net compact frame work 1.0, is there any notification class in .net compact frame work 1.0
Thanks in advance
Yogesh R.
|
|
|
|
|
Why are you still using the 1.0 Framework? It is harder to develop for the 1.0 Framework and it isn't supported on all current devices. Your 1.0 app may run under the 2.0 framework in compatibility mode but you'll need to do more testing to ensure that the differences in the framework don't surface through your application.
The SystemState class has a member called BatteryStrength. You can add an event handler to get notification when it changes by a significant amount.
|
|
|
|
|
OK thanks for your reply. If i install Windows CE 6.0 on my device, can i use .net 2005? Because in .net 2005 there is no option for Windows CE 6.0 when i search under Create Project-Visual C# - Smart Device - Windows CE 5.0
I am confuse that which .net version i have to use for Windows CE 6.0.
Please update me
Thanks
|
|
|
|
|
For Windows CE to be available in the new project types you need to have the Platform Builder installed. The appropriate platform builder installation comes with the development hardware you've purchased.
|
|
|
|
|
ok currently i have Windows CE 5.0 installed on my computer.Now I am going to install Windows CE 6.0 on my computer. is it ok?
|
|
|
|
|
I want to deploy an application developed in Visual Studio 2008 under smart device on Windows mobile 6. I have used .NET 3.5 while developing the application. Is there any need to install .NET Compact Framework 3.5 on Windows Mobile 6? Please provide the required URL to download the .NET CF 3.5
|
|
|
|
|
If you are deploying the application using Visual Studio it will automatically detect the .Net CF version installed and install a newer one if needed. If you need to manually install the .Net CF onto another device. You can find a link to the distributables in the article Windows Mobile Development Without Visual Studio[^]
|
|
|
|
|
Thanks a lot. I found the link very useful. I could install .net CF 3.5 on Win mobile 6.0 handset.
My application involves an access to the data from SQL server mobile database in Visual studio. When i run the application on Win mobile 6.0 handset i cannot access the database but i can see the forms designed in my project. Do i need to install SQL server compact edition cab file on the handset? I went to the path C:\Program Files\Microsoft SQL server compact edition\v3.5\Devices\wce500. Here i found many folders containing cab files for SQL server compact edition. Please let me know which is the file needed to install. Also while running the application on Win mobile 5.0 emulator i used the connect the database to my project through Query Analyser 3.5. I could not see the Query Analyser 3.5 on Win moblie 6.0 handset.
Please help with this.
Thanks in advance.
|
|
|
|
|
The pre-installed version of .NET Compact Framework in Windows Mobile 6 is version 2.0 SP1.
So if you are not using any APIs that are new to 3.5 since 2.0, I would suggest that you simply change the target framework in Visual Studio.
/André
|
|
|
|
|
Pls. can anyone out there tell me if ever I've developed an applications for MS Windows XP using MS Visual C# or MS Visual C++ do I need permission? royalties ? some kind of License payment to Microsoft or a kind of liability on me for using their platform?
thank you...
|
|
|
|