SQL Server Express connection string

Question

<configuration>

<connectionStrings>

<add name="ConnectionString1" connectionString="Data Source=(.Lens\SQLEXPRESS)\DatabindusingWPF.sdf; Initial Catalog=COMASTER; Persist Security Info=False; "/>

</connectionStrings>

</configuration>

I'm pretty new to this so bear with me..

 

I'm trying to create a connection string in an app.config

It doesn't work.  I get an error server not found or accessible. 

I'm trying to connect to my database on my local with Sql Express 

 

 

Answer 1

I found my own solution... I found that I could not have a DateTimePicker control bound to the dataset. When the DateTimePicker control was bound to the dataaset, the data would not display in any of the controls on the form. When I "un-bound" the DateTimePicker control, then the data woudl display properly. I bound an edit box to the date column and then updated the DateTimePicker control when the value of the edit box changed.