Solved

.Net Compact Framework Questions Connect SQL Server

Posted on 2004-04-14
3
414 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
3 Comments
 
LVL 37

Accepted Solution

by:
gregoryyoung earned 100 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Checking a checkbox based on SQL DataReader boolean value in ASP.NET(VB) 2 45
bound data table problem 2 40
Why use this lambda? 12 60
Upgrade code from VS 2010 to VS 2015 7 32
Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
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…

740 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