?
Solved

.Net Compact Framework Questions Connect SQL Server

Posted on 2004-04-14
3
Medium Priority
?
417 Views
Last Modified: 2008-02-01
Using the VB .Net compact framework to develop windows CE applications. Brand new to this have done extensive work in VB 6 connecting to access and SQL alike but i cannot figure out a couple things with the compact framework.

1. I need a connection string that is made of the server, database, username, password, and provider from textboxes.. Would like to use a Adodb.Connection i am familiar with this.

2. Need to declare a recordset and then open using "Select * From Table Where Blah = 'Blah'", ConABC

Thanks in Advance Greg.
0
Comment
Question by:gharman
[X]
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
3 Comments
 
LVL 37

Accepted Solution

by:
gregoryyoung earned 400 total points
ID: 10825616
You can do this easily using ADO.NET

The System.Data.SqlServerCe namespace exposes SQL Server CE in the .NET Compact Framework. In addition, the .NET Compact Framework also includes the System.Data.SqlClient namespace for developing Windows CE-based applications that directly access databases in SQL Server 7.0 or later.

Pretty much the entire System.Data.SqlClient namespace is there so it the same as in windows ...

There are a TON of tutorials on how to connect to a db and issue a query using this namespace (they should apply pretty much as is in the .net compact framework)

intel offers a brief web course ... https://shale.intel.com/SoftwareCollege/CourseDetails.asp?courseID=126
0

Featured Post

More Than Just A Video Library

Train for your certification. Learn the latest DevOps tools. Grow your skillset to do better work.

At Linux Academy, we release new training modules every week so you'll always be up to date on the latest tech.

Question has a verified solution.

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

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 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