Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

How can I bind a form on a pocket pc app to a database

Posted on 2004-09-08
Last Modified: 2010-04-23
Using VB .Net I would like to bind a form to a SQL database or an Access database. Right now we use unbound forms and fields and send the data on the OnKey event. This is not bad for adding data but to edit existing data this will be much more difficult than using a bound form.
Question by:AccessYourBiz_Com
  • 2
  • 2
  • 2
LVL 27

Expert Comment

ID: 12007224
There is a good example of you are using VS2003 at this path...

C:\Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows CE\Samples\VB

Author Comment

ID: 12010309
I took a look at some of this stuff and it all looks good but I wasn't able to decifer which code does what. If you know of any code samples you can point me to or post in this thread that would help. I looked mostly at the NorthwindCE application.
LVL 70

Expert Comment

by:Éric Moreau
ID: 12010324
Check the Inventory application.
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Author Comment

ID: 12026820
Thank you emoreau, I took a look at it but I think my level of expertise is not good enough to figure out what code actually does the binding. I am very familiar with Visual Base for Applications but this stuff looks greek to me. If you could be more specific that would be great or post a coule of line of codes with a comment or two.
LVL 70

Assisted Solution

by:Éric Moreau
Éric Moreau earned 250 total points
ID: 12026983
Open the sample and trace it!

The loadSQLData method is actually retrieving data from a SQL Server.

The cboCompany_SelectedIndexChanged event fill the controls with the selection from the combobox.
LVL 27

Accepted Solution

planocz earned 250 total points
ID: 12027076
look at
  Public Sub InitCustomers()
in NorthwindCE App. on the ControlCustomer Class.

also  Public Sub InitEmployees()
on the ControlEmployees Class.

This starts at   Public Sub ActiveNorthwindCustomers()

on the FormNorthwindCE form.

The best way is to step thru the code and learn why Mic$oft does it this way.

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question