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
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!
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