You should be able to connect to any edition of Sql Server using the
SqlClient class.
This includes handy things like SqlConnection, SqlCommand, SqlParameter, etc.
Peter
I'm not sure what SQL Workgroup is, but if you can get a connection to
the box it runs on, say in Windows Explorer, than you can get to it
through .net code. Just make a note of the server name ( or IP address
) and if there are more than one instance of SQL Server running on the
server, which one, then write up a connection string.
When making a new Connection in C# Express Edition I can choose from
following data sources:
- Microsoft SQL Server Database File (SQLClient)
- Microsoft Access Database File
When looking at sample application in C# more data sources are available.
The one I think I need is "Microsoft SQL Server". Through Database Explorer
in C# Express I can not add data sources. This makes me think C# Express can
only be used with the SQL Server 2005 Express Edition and probably I have to
change to another (Standard or Professional) version of Visual Studio 2005
to make a connection with SQL Server 2005 for Workgroups.