|
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...
|
|
|
|
|
no, you don't need to pay royalties. an dyou've posted your question in the wrong forum.
|
|
|
|
|
I am looking for documentation on what features are available in the compact framework with dealing with pocket excel. EX: how to write/read. and anything else.
Thank you.
I can't think of anything cool and nerdy to say.
|
|
|
|
|
I don't think there's anything exposed to the .Net Framrwork directly. If you can find COM interfaces for pocket office then you could create .Net wrappers from them.
|
|
|
|
|
i m new to blackberry programming and For the very first time developing a simple Helloworld progrm (following instructions and code using this link
http://www.devx.com/wireless/Article/27869/1954[^]
but when i Build the project it shows following error
Building Helloworld
D:\Installed blackberry sw\bin\rapc.exe -quiet import=..\lib\net_rim_api.jar codename=Helloworld Helloworld.rapc warnkey=0x52424200;0x52525400;0x52435200 "D:\Installed blackberry sw\bin\HelloWorld.java"
I/O Error: CreateProcess: javac -source 1.3 -target 1.1 -g -O -d C:\DOCUME~1\Shaina\LOCALS~1\Temp\rapc_163c02ce.dir -bootclasspath ..\lib\net_rim_api.jar -classpath ..\lib\net_rim_api.jar "D:\Installed blackberry sw\bin\HelloWorld.java" error=2
Error while building project
Please if anyone have idea may be some project settings(path etc) then plzzzzz suggest solution
thanks in advance
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
