AcquiVision: Data Acquisition, Logging, Analysis, Test, Measurement, Instrumentation and Control Software

Website Index

Home
Contact Us
Financial AcquiVsion
Data AcquiVision
Outsourced Projects
Computer Help
SQL Databases
Website Design / Hosting
Articles
SQL Server
SQL Server datediff
Working From Home

We provide Custom, Bespoke and Open Source Database, Data Acquisition, Data Logging, Test, Measurement, Instrumentation, Control, Accounting, Business, Financial and Management Software solutions. We have been looking after our customers since 1994.

DataTable, DataSet, BindingSource, TableAdapter does not update or data missing

Problem with Visual Studio SQL Server mdf file data disappearing. Right click Properties. You probably have set to overwrite every time, so when you rebuild, your data gets overwritten and never shows in VS because a copy was updated.

Get around this by Excluding the mdf file from VS, so it stays in the same folder as my code, Attaching the mdf in Management Studio Express, and then using a Connection String to SQL Server Express. This way, my data stays with code and gets backed up with the code.

Like keyword

In SQL Server, the word �Like� is case sensitive with OleDb.