Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

New Commands in SQL CE 3.5 SP1 ? Expand / Collapse
Author
Message
Posted Sunday, November 2, 2008 4:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 2, 2008 4:43 PM
Points: 0, Visits: 9
Hi,
I am trying to port over from SQL Server 2005 Express
to > SQL Server CE 3.5 SP1 (sql 2008 Commands mabee?)

Want to use a query internal to Visual Studio 2008's Query
Builder...

Here is How the code looks in the Query Window of VS 2008 VB... Do NOT wan't to use Linq...!

SELECT [Record Number], Date, Car, Miles_Start, Miles_Stop, Gallons_FillUp, Miles_Stop - Miles_Start AS Miles_Total, (Miles_Stop - Miles_Start) / Gallons_FillUp AS MPG
FROM Sheet1_Table
ORDER BY Car, Date DESC

It processes fine but does not work: Just Want to Preform Basic math on the Data Table. Add, Subtract, Devide and Multiply.

In the "Advanced Options" of Query Builder the " Refresh The Data Table" Is greyed out...

Any Ideas where I can get a good command reference or PDF
Book on SQL Server Compact Edition 3.5 sp1 ? ;)

Any and all help would be appreciated!
Post #595622
Posted Thursday, August 6, 2009 7:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 6, 2009 7:05 PM
Points: 1, Visits: 0
Hi,

It uses Microsoft's query builder to edit the CommandText property among lots of other designer things. It's also open source so you can peek under the hood. Be warned though, in order to use Query Builder, you'll need to have a fully-functional GetSchema() method on your Connection object.


----------------------------------
database browser
Post #766641
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse