Connection String not found in Application (My) Settings VB.Net

[vinitfichadia]

Hello friends,

At the time of using table adapters in vb.net, suddenly i got error specifying that -> Unable to connection string for object My Settings. Connection String could not be found in application settings or the data provider associated with Connection String could not be loaded.

But Connection String is already present in My Settings with the same name as of that in app.config file.

Please help as i m not getting exact solution to these from last day.

Thanks to all very much.

[tekeste]

I don't know how your connection string look like, check it with this one:

Dim con As New SqlConnection
con.ConnectionString = "server=(local);database=yourdatabase;
_Trusted_Connection=True"

Dim adapter As SqlDataAdapter
adapter = New SqlDataAdapter("your SQL statements", con)
Dim dsMytable As New DataSet
adapter.Fill(dsMytable)

[Shashi Sadasivan]

If you are using strongly typed datasets to compliment ure adapters, u can try making another dataset, connect a table to it from your database, this will create the connection string for you, Check this connection string with the one that you made in app.config and see what needs to be changed / modified!!