Password in SqlServer 2005

[SajjadZare]

How can I set a password for DB file and just open it in C# ?

[Abhijit Jana]

SajjadZare wrote:

How can I set a password for DB file and just open it in C# ?

You want to set SQL Server Password using C# ? Or You want to open a database which is already password protected ? If you want to open the database which has password, then you need to mention it in ConnectionString.

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you. View My Latest Article

[Mycroft Holmes]

I think you are asking how to open a .MDF without having SQL Server, that is open the mdf directly from C#. You can't, sql server requires a SERVER. I'm not sure if SQL Express will allow you to open the mdf directly. Access will allow you to do this but you need the Jet engine installed.

Never underestimate the power of human stupidity RAH

[Andy_L_J]

SQL Express requires the DB Engine also.

I don't speak Idiot - please talk slowly and clearly I don't know what all the fuss is about with America getting it's first black president. Zimbabwe's had one for years and he's sh*t. - Percy Drake , Shrewsbury Driven to the arms of Heineken by the wife