[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

.Net Compact Framework Questions Connect SQL Server

Posted on 2004-04-14
3
Medium Priority
?
421 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
1 Comment
 
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
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…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month19 days, 12 hours left to enroll

873 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