Please tell me how can we attach SQL Server database (SQL Server 2005) during installation or after installation using c#.net (desktop application). We can create a form to get details of connection string (user id, pass, server name etc..) . please tell me how can we automatically attach database with SQL Server using .net
+2
A:
Execute a full create database script with your tables, SPs etc. the same way you do any insert i.e. call ExecuteNonQuery method.
Is it what you were asking or you need something more?
Ismail
2010-06-09 06:51:04
its a good idea.. but i was asking about attaching database programmatically
Rajesh Rolen- DotNet Developer
2010-06-09 07:12:14
Do you mean that you already have .mdf file and you want to attach it?
Ismail
2010-06-09 09:44:06
+2
A:
You can use the SQL Express Edition it attach automatically database.
Govind KamalaPrakash Malviya
2010-06-10 04:51:58