Create Database Connection in the C#.net

[ani.since1982]

hello all,

I have database named 'Marketing', and want to bound DropDownList control with it using 'add connection' dialog box in the C#.net.

I gave datasource: 'Microsoft SQL Server Database File (SqlClient)'. And when I give DataBase file name as 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Marketing_Data.MDF', I get error while testing the connection:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that
under default settings SQL Server dose not allow remote connections. (Provider:SQL Network Interfaces, error: 26-Error Locating Server/Instance specified)".

So what DataBase File name I should give here for completing the database binding?

Thanks

[Hack]

Well, first you need to ensure the database is setup to accept remote connections.

By default, it is not.

[Phil Weber]

Ignore the error message; if you're running SQL on the same computer as your application, your problem has nothing to do with remote connections.

Which version of SQL are you using? Is it SQL 2005 Express, or SQL Server? What does your connection string look like?