Table Adapter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

onecorp - 30 Aug 2006 07:15 GMT

I have tried to use the 'add new item' process to add a dataSet to my project.

When I try to build my project after completing the tableadapter wizard, I
receive the following error:

Unable to convert input xml file content to a DataSet. Requested value
'ConnectionStrings' was not found.

During the completion of the wizard, I successfully connected to the
database and can preview the data, but once the wizard steps have been
completed, a table adapter class is not created and the error appears.

Any assistance would be appreciated.

Thank you

Onecorp

Reply to this Message

Luke Zhang [MSFT] - 30 Aug 2006 10:19 GMT

Hello,

I reply you in another thread with same issue. Please refer to that thread
in microsoft.public.vsnet.general.

Sincerely,

Luke Zhang

Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

onecorp - 31 Aug 2006 01:38 GMT

Dear Mr Zhang

(refer also same day post in name of Table Adapter)
I deleted my previous efforts (including the database ) and started
again...........

There appear to have been two problems:

When I created my database (which is under the named sql instance), it saved
it in a sub folder under, for example, MSSQL4...... ......saved as
MyDatabase.Mdf. This is where all my 'user' created databases save, compared
to the shipped samples being under MSSQL3 For whatever reason, I cannot
successfully refer to the database when the database is under MSSQL4 when I
use the tableadapter wizard.
I re-created the database and this time it saved under MSSQL3 as MyDatabase.
I can now build my project and successfully access the tableadapter classes
as intended.

The second problem was what you initially suggested with regard to the
Primary Key field.

Thank you for your assistance.

> Hello,
>
[quoted text clipped - 27 lines]
>
>

Reply to this Message

Table Adapter

Free Magazines