Re: New to .Net

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 05/29/04


Date: Sat, 29 May 2004 13:37:32 -0400

Paul:

You can reference full SQL Server from your device pretty much the same as
you would from the desktop. Make sure you have a reference the the
SQLClient library.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_sqlclient_705.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_sqlclient_705.asp
 Using SQL Server CE is another pretty cool way to do things, but I don't
get the feeling that's what you are asking about. I'm not sure how much you
are asking about, but basically you'll create a new project, choose Smart
Device Appliction , the Smart Device Application wizard will ask you to
target the platform (Pocket PC) and type Windows Application (unless you
want to create another type). You can then add your refernces, build your
ui and do things pretty much like a full framework app. You have two
deployment options, the device or the emulator. If you have your device
cradled it will load the framework if it's not there (this is when you
build), and load your app. Debugging is somewhat limited, I'll warn you of
that now but you can still set breakpoints and most of the major things.
Inherently there's not Debug.WriteLine or Console.WriteLine but you can use
your own preference to notify yourself of what's going on.

Anyway, the first place to start if you want to get into CF development is
www.opennetcf.org .They have many samples and to be honest, I'd download
their SDF before I did much more if I had any plans on doing any serious CF
development. You don't technically need it just to hit a SQL Server and pull
over data, but it fills in the gaps on the CF and if your app is anythign
more than a recreatinoal thing you're doing to play around, the OpennetCF
library will help you out tremendously.

The quickstart tutorials will also be helpful
http://samples.gotdotnet.com/quickstart/compactframework/doc/default.aspx
This should get you on your way.

HTH,

Bill

-- 
W.G. Ryan MVP Windows - Embedded
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Paul Ilacqua" <Pilacqu2@twcny.rr.com> wrote in message
news:%23jJdQAaREHA.904@TK2MSFTNGP12.phx.gbl...
> I have an Dell Axim with Windows Mobile 2003. I also have VB net and am
> experienced at VB 6 & SQL Server. How can I write a quick program to get
to
> my SQL Server and then I can expand on the concept. Documentation is very
> little in writing a quickie and getting it onto the hand held. Please help
> if you can.
> Thank you
> Paul
>
>


Relevant Pages

  • Re: SqlExpress distribution and access rights
    ... Is this app with SQL Server Epxress a server app or a desktop app? ... Since you want useraccess the SQL Server with Windows integrated security, and you, of course, do not know what user account the user is using when developing the app. ... you can also incorporate the Windows local user group setup into your installation package. ...
    (microsoft.public.sqlserver.msde)
  • ADO.NET 2.0 & MSDE & Win98
    ... Framework 2.0 which must be deployed on Windows 98 platform. ... The MSDE will ... be installed on Win98 as the SQL Server to which the app will connect. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Bizzare SQL Network Error
    ... The bizzare thing is that, the same connection string, the same code to ... In a windows APP it works fine, in a Web APP I get ... >>I am trying to connect to a default instance of SQL Server 2000 Enterprise ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Bizzare SQL Network Error
    ... Your ASP.NET request is not being run under the same windows ... account your ASP.NET requests are being run under. ... >I am trying to connect to a default instance of SQL Server 2000 Enterprise ... I take the same connection string from the web app, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO/MDAC on Terminal Server
    ... XP database system to SQL Server 2000. ... front end is running on the Terminal Server. ... MDB file due to fixes and modifications, ... "missing reference" error as the MDB file opens up. ...
    (microsoft.public.data.ado)