Solved

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

Posted on 2004-09-08
6
125 Views
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.
0
Comment
Question by:AccessYourBiz_Com
  • 2
  • 2
  • 2
6 Comments
 
LVL 27

Expert Comment

by:planocz
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
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
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.
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 12010324
Check the Inventory application.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 3

Author Comment

by:AccessYourBiz_Com
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.
0
 
LVL 69

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.
0
 
LVL 27

Accepted Solution

by:
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.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Format column on datatable 7 28
More on Time zones in vb 2010 12 37
Visual Studio 2013 Shortcut (VB) 4 34
Variable Event ? 3 20
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

914 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now