hi,
there, i am coming up with this form and i am having problem with my connection string .i am unable to enable the user instance. It is because of that, I am unable to connect asp with the database. My connection string in the web.config is as below:
<connectionStrings>
<add name="ConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachdbFileName=|DataDirectory|\DataBase1.mdf;Integrated Security=True"
UserInstance="True" providerName="System.Data.SqlClient" />
</connectionStrings>
At the same time, I am not sure how to enable the user instance.please help me on that step by step of where I should enable the user instance. in the codes above, the userInstance becomes an error. The error is 'the 'userinstance' is not declared'.
Please help.thank you