I am trying to port over from SQL Server 2005 Express
to > SQL Server CE 3.5 SP1 (sql 2008 Commands mabee?):w00t:
Want to use a query internal to Visual Studio 2008's Query
Here is How the code looks in the Query Window of VS 2008 VB... Do NOT wan't to use Linq...!:hehe:
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
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... :w00t:
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!
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.
Viewing 2 posts - 1 through 1 (of 1 total)