?
Solved

.Net Compact Framework Questions Connect SQL Server

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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Suggested Courses

589 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