Click here to Skip to main content
15,921,371 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello. I created local DB DBSimple.sdf with some tables. Then i published code:


C#
private string CommandText = "SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM Customers";

private string ConnectionString = "";
SqlDataAdapter dataAdapter = new SqlDataAdapter(CommandText, ConnectionString); 

What is ConnectionString must be for local file DBSimple.sdf? (It Database showes at Data Connections/Server Eplorer)
Posted
Comments
[no name] 31-May-13 10:02am    
www.connectionstrings.com
Jardin1 31-May-13 10:08am    
There is connection to mdf, but to sdf i did not find
[no name] 31-May-13 10:10am    
Funny, I found in about 10 seconds. http://www.connectionstrings.com/sql-server-ce
Jardin1 31-May-13 10:30am    
I must set full path to sdf?
ZurdoDev 31-May-13 10:33am    
You need to reply to the comment directly so that the user who made the comment is notified. Please do not post a new comment to your own question.

1 solution

I would suggest you to start here: ADO.NET Overview[^]. Please, read all related articles.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900