Preparing test data with SQLCE - latest release RC1

  • Thread starter Thread starter Garry
  • Start date Start date
G

Garry

I want to prepare test data in SQLCE where the dataTables in the database
are predefined. A VB.NET app

I tried to use the DataSources facility in vs2005 IDE but cannot see how to
input new datarows or edit existing rows. (The existing rows were from a
migrated Access Data Base file.). The tables are displayed in the data
designer and a preview is readily available.

INPUTTING new data is the problem. The Data Provider in the Wizard appears
in the list as Microsoft SQL Server Anywhere Edition.
BUT, on my test Vista machine, it appears as Microsoft SQL Mobile edition.
Is there any resolution to these confusing naming problems?

Can anyone 'point' me to material on this point or give me an understandable
way of doing this.(Updating the data)

I realise that I could write a relatively simple data bound DataGridView app
to do this BUT, I WANT TO USE Microsoft's much vaunted Data Designer tools.
So much has been written about them.

I remember them so well from VB6 in 1998 and they were quickly discarded by
most serious programmers in favour of solid and meaningfull code.

SQLCE - Previously called SQL Server Anywhere although it is not a Server.

I feel sure that Microsoft employs reams and reams of people to promote
these confusing and different names.

Garry
 
I've found that using the SQL Server Management Studio tools to open an
existing SQLCe table is easiest. You can also write a script processor to
import data. I include examples and instructions in my new EBook on the
Compact Edition. See www.hitchhikerguides.net FMI.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
 
Back
Top