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: