locked
configuring TableAdapter RRS feed

  • Question

  • I am using vb.net express. I have 2 tables in my database. One table called EmployeeName has an EmployeeID which is the primary key and a last name and first name column. The other table called WorkInformation has as its columns EmployeeID, DateWorked,HoursWorked & WeekEnding.

    I have configured a TableAdapter using the TableAdapter Configurization Wizard which  selects information from WorkInformation based on EmployeeID and WeekEnding. My question is why a DeleteCommand and an UpdateCommand was not automatically developed. I want to be able to make changes from that table.

    Thanks

    Ken

     

    Saturday, October 29, 2005 11:12 PM

Answers

  • Hi Ken,

    Does your query uniquely define the row (does it only return 1 row all the time)? If it does not, update and delete command cannot be defined.

    Best regards,

    Monday, November 7, 2005 9:48 PM
    Moderator