Search results for query: *

solved it using SUM (CASE ) statements

Hey there... im have a query im not sure how to do i have 3 tables, Customers, Contracts and Jobs Customer - iId, sName Contracts - iId, iCustId, mCleaningCost, mWashCost, mServiceCost Jobs - iId, dJobDate, iCustId, bCleaning, bWash, bService i means integer type, m means smallmoney type...

strange that because normally if all else fails a reinstall or repair of VS normally would correct the probelm

have you tried the windows ce emulator? When you create a project it ask you whether which do you want to target, i always pick windows ce because at least then you can deploy debug on either. also maybe download the pocket pc 2003 emulator...

you may need to put in the port number that sqlserver uses. try this as your connectionstring "Data Source=192.168.2.114,<PORT_NUMBER>;Initial Catalog=new_one;User ID=sa;Password=1234;" If that doesnt work it sounds like wrong IPaddress, wrong user, wrong password, firewall blocking access.

in the code you posted you are not creating an instance of the SqlConnection or the SqlCommand. Dim l_sqlConn As New SqlConnection("Persist Security Info=False;Integrated Security=False;Server=192.168.1.14;initial catalog=new;user id=sa;password=14;") l_sqlConn.Open Dim l_sqlCmd As SqlCommand...

you can add a reference to SQLClient inside your Compact Framework application. then you can connect to sql server directly from your device (providing the device has network connection (Wifi,GPRS, or over ActiveSync) sqlconnection string Persist Security Info=False;Integrated...

There are no such capabilities on SQL Mobile, instead you will need to use table constraints eg MyCol int REFERENCES MyTable2(MyColumn1) ON DELETE CASCADE have a look at http://msdn2.microsoft.com/en-gb/library/aa237902(SQL.80).aspx there is a section on FOREIGN KEY...REFERENCES

In VS2003 this happens to me and i either have to do one of the following: 1. Rebuild the Project/Solution 2. For each form that is not showing code change the build action of the form from Compile to None, and then back to Compile again 3. At the top of the code Inherits...

you could use a listview... this allows you to have checkboxes and text along side

yes if the device has access to the network then you should be able to browse shared folders on computers. try the openfiledialogbox and specify \\<computername>\<folder>

you need to use sqlserverce namespace for data access. oledb is not available

http://www.crlab.com/mysqlnet/

for what exactly.... connection to pocket access or desktop access?

check out these links https://blogs.msdn.com/netcfteam/archive/2005/10/11/479793.aspx http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetcomp/html/deploy_cf2_apps_cab_msi.asp

nope very little, its just a dll that you add to yout project. when you download it, there is instructions on how to add the library etc...

hi this will help c# to vb conversion http://www.kamalpatel.net/ConvertCSharp2VB.aspx i use the 3rd party control, it only costs like a couple of dollars, and it ll save you time. Some devices provide SDK that allow you to save signatures as bitmaps

here are a few links http://www.microsoft.com/downloads/details.aspx?familyid=07675EA6-CC67-4033-80BE-96F0C00B0CE6&displaylang=en http://www.codeproject.com/netcf/PPCSignatureApp.asp http://www.codeproject.com/netcf/Signature_Capture.asp...

Pocket Access (.cdb) is not support in the Compact Framework 1.0 or 2.0. You will need to get the following 3rd party tools to access the pocket access database in the compact framework Link: (http://www.inthehand.com/ADOCE.aspx) Samples: (http://www.inthehand.com/library/adoce/sql/)

have you tried using single quotes? what does the error message say?