SIMPLE DATA RETRIEVING FROM SQL DB

Jan 3 2013 10:12 AM

DB Type: SQL Server Compact 3.5
DB Path: C:\Users\Ali\Documents\Visual Studio 2010\Projects\UCS\unitsdb.sdf
Table: tblAcceleration
Fields: fldUnitName (nvarchar), fldCoefficient (float)
What I Need: Codes (namespaces, connection, sql query...) which give me the fldCoefficient value for a specified fldUnitName (example: WHERE fldUnitName="centigal"). And finally give the result to a label.
Thanks in advance.

My table's preview:

Answers (1)

Need code for export to excel -- Confused!!!

Unable to cast object of type 'System.Data.DataRow' to type