Member Avatar for unika010690

i have a project..i need to search the user info,,

the search by cbo has this items :
Finance Name
Address
Finance Type

when i click the search button the data from database should load into the data gridview in the middle when i select one data it must be display in the textboxes..
employee name is from General.Person table (Lastname,Firstname,middlename)
department is from HumanResources.Department table (DeptID=description)
Login name and password from General.UserMaster table
and how am i going to code the update password???we are using n-tier application,,
pllsss help,,

untitled.bmp (557.87 KB)
Edited by unika010690 because: i need to add image
  • 2 Contributors
  • 1 Reply
  • 95 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

1. You can create a view based on the records of the JOIN between the relevant tables for the purpose of search.
2. While updating you need to update only one master table by pulling / selecting record from the above mentioned view.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.