Tags: configuration, configuring, create, database, directly, generatedbdirectmethods, greyed, methods, microsoft, mysql, oracle, server, sql, tableadapter, updates

TableAdapter Configuration: "Create methods to send updates .." greyed out

On Database » Microsoft SQL Server

817 words with 2 Comments; publish: Sat, 05 Jan 2008 23:37:00 GMT; (25091.80, « »)

While configuring a TableAdapter I noticed that the option "Create methods to send updates directly to the database (GenerateDBDirectMethods)" is greyed out.

Can a TableAdapter only have one table in order to create the methods for sending the updates directly to the database?

If so, what is the work-around?

The TableAdapter that I am trying to create uses the following statement to fill its DataTable:

SELECT Client.Name, Users.FirstName, Users.LastName

FROM Users INNER JOIN

Client ON Users.ClientId = Client.Id

Thanks for your response in advance!

All Comments

Leave a comment...

  • 2 Comments
    • You cannot use the autogenerated ones on SQL statements that use joins. The workaround is to write the SQL statements yourself.
      #1; Sat, 05 Jan 2008 23:38:00 GMT
    • Darrel, thank you very much for the clarification.
      #2; Sat, 05 Jan 2008 23:39:00 GMT