Database Info

[help] vb .net database development

hellooo,
i am looking for a good tutorial to help me get started developing a simple application which will run on a Windows CE 4.1 device and will connect via Wifi to a local sql server and return/store data.
I am a bit lost since i dont even know where to start, i.e. i need visual studio .net alone or another SDK or someting?
any pointers to a suitable tutorial will be much apreciated.

Not too sure what you need for CE4.1 but this is a good place to start
MSDN Windows Mobile
and here's one way for your DB I think
http://msdn.microsoft.com/mobility/...ry/en-us/dnppcgen/html/intro_winmobile_vb.asp
Haven't looked at the code but you can use either
1)SqlDataAdapter and SqlCommandBuilder to get the results into a DataTable
or
2)SqlDataReader

thanks kev, msdn should have enought info to get me started.
saw that tutorial on msdn but it wont do, since it connects to the sql server via web services or someting, i want to connect directly to the server and execute sql queries.

if you use an oleDBdaptor or sqladaptor it will be transparent for the
system that you are a pda and not a normal pc
wifi is transparent too it's all LAN

Just checkout the classes I mentioned they give examples: SqlDataReader SqlDataAdapter

Can a PC application access files through ActiveSync?

More specifically, can I access the file system from a C# application on my PPC while connected with ActiveSync 4.5?
I figure since explorer can browse it under "Mobile Device"\"My Windows Mobile-Based Device"\ I should be able to as well, but so far no luck.

I read that you want to network file share your PPC to your network. Then it can be seen.

Thresher said:
I read that you want to network file share your PPC to your network. Then it can be seen.
Click to expand...
Click to collapse
That would be awesome, then I could use a url like \\MyPPC\??
But I can't find any documentation on creating a share on my PPC (an AT&T Fuze, bythe way), just how to map to a network file share from a PPC.
There are utilities to backup your device, so certainly you can copy files across. I was hoping I just lack some knowledge of device naming of explorer extensions. "$\Mobile Device" doesn't work.

home automation and remote desktop connection

I was wondering if there was any software for either, home automation or remote desktop connection. I've searched for home automation and can't seem to find a definitive answer. As far as remote pc goes... I want to be able to see and access all the files on my laptop, from my phone.

you could host a ftp server on your laptop

^ would that allow me to access all .doc and .jpeg files... oh and also music files as well... those are the only extentions i'm really interested in accessing.
sorry for the poor post quality, i'm posting from workon my raphael

absolutly, I am using guildFTPd(freeware) to host. However I can't use TotalCommander to see the dir/file structure, I have to use FTPview. There are other free ftp servers as well (FTPShell Server). Just make sure you use strong security, I do get occasional people/bots trying to getting in the server.
There are also applications like RemoteAdmin, PCAnywhere, VNC viewer to take control of your remote machine ... but if all you want is to access files the FTP approach is better performance wise.

is there some sort of LogMeIn hamachi client for WinMo? I know for PC's it puts two computers on the "same network". that might work, if there is...

You could also try running Orb (free) on your laptop if you want to be able to access files remotely. Allows for all media files specifically but also has a built in file browser.
Also allows for streaming video etc (can be great if you've got a TV capture card on your laptop at home and you want to watch TV from a remote location)

dont know anything about home automation, but
take a look here:
http://www.z2software.com/Remote2PC.htm
allows you to control your pc remotely from your phone.
Also, there exists a mobile version of remote desktop connection. Don't know how to get it, though, as it was already cooked into the rom i'm using (PROven ROM 2.4 21018 UNPROTECTED by qsqa) .

You can both remotely control a PC and access file shares with features built into Windows Mobile.
To control a PC
I have successfully used Remote Desktop Mobile on my Fuze (standard ROM) to control my home PC. My home PC is Windows XP Professional (XP Home does not include the RD server). It works great considering the screen size. This solution is much simpler than installing 3rd-party software on both the phone and the PC.
To access files on a PC
I have used File Explorer Menu | Go To | Open Path | New Path to access file shares. I haven't done this a lot but it seems to work fine. Configuring a share is much simpler than installing and configuing an FTP server. BTW, Windows XP Professional includes an FTP server.
To use either of these features you must have an appropriate network path from your phone to the PC. The easiest way is to use your home wireless network. Then you only need to worry about the software firewall on your PC.
If you use the provider's network, you must properly configure all firewalls to allow appropriate ports, and configure your router to port-forward appropriate ports to the PC. You must also either (1) have a static IP for your home network interface, (2) track your dynamic IP address as it changes, or (3) use a service that maps a host name to your dynamic IP and automatically tracks changes. It might be easier just to store files on a web site, then you don't need to even keep the PC turned on.

Lumia 800 shared documents

Hi guys,
I´ve got one question, is it possible to create file transfer on wifi? I want create wifi network something like family group in Windows 7. And if its possible do this betwen WP and android phone or WP and windows 7 PC.
Thanks a lot.

No, not possible; but you can try DFT Bluetooth file transfer if you have a fully unlocked or rooted phone and see if that works. Currently there is no way of doing what you are asking via email, MMS or Wifi.

It doesn´t working via e-mail too ?

Root Webserver (see my sig) allows easily taking files off (or putting them on) a Windows phone via WiFi. It's not the most elegant approach, but it's easy to use.
There has been talk of somebody implementing SMB (the network protocol that is used for Windows networking) using the sockets APIs in WP7, but I'm not even sure the official APIs are complete enough and even if they are, it'll be quite a bit of work to implement (the SAMBA project has been trying on Linux for years, and is only mostly there).
I'm quite certain it's possible to attach arbitrary files to email, but nobody has found the way *yet* so that's not currently possible. Also, the email client isn't going to let you save attachments to arbitrary locations, because it's designed to work with the very low permissions of the OS by default.

Developing WP7 file Transfer app

Hi, I'm a final year Computer Science Student. My Final year project is to design a windows phone 7 app for transferring files from a remote database /sever to the windows phone device.
I have never been taught any C# or windows phone development. So far I have developed a windows phone 7 client app which connects to an SQL Server 2008 database, I can query the database from the app and return and display the text stored within the database tables. I am also able to store a picture in the database as binary data.
Can anyone advise me is it possible to store pdf and office documents within the SQL server database and download them to the windows phone 7 client and then open/view these files on the device. I believe that any files must be downloaded directly to isolated storage on the device but that there are restraints where that these files cannot be accessed by any other apps on the phone.
Any help or advice would be greatly appreciated..

It's possible to open supported media and documents (pictures, PDFs, etc.) from an app, I'm pretty sure (for example, see the SkyDrive app). I know that it's possible using native code and a couple of other mildly undocumented features. Using only official APIs... never tried, but I think it can be done (I'm just not sure how).
Unless you use the undocumented ID_CAP_FILEVIEWER capability in your app (or use one of a number of available hacks), your app will not have write permissions anywhere except in its isolated storage. Officially, one app can't access the isolated storage of another app, although the Office stuff may bend the rules somewhat.