Thomas Lamb

Thomas Lamb

  • NA
  • 3
  • 413

Need help ASP.net

Aug 15 2022 3:14 PM

Looking for direction/tutorial, using VS 2022, C#, MS SQL Server, to perform CRUD operations on various tables.

tblEmp - empID, nameL, nameF, nameM, eMail, pHome, pWork, dEntered

tblAddr - addrID, empID, primAddr, addr1, addr2, city, st, zip, dEntered

tblRoles - rolesID, empID, roleType, wPlace, dEntered

I have so far, migrated my MS Access B/end data to my SQL Server. My f/end, MS Access form would present to user an Employee form, with two sub forms for Address and Roles tied together with empID. I would like to present to the client an option of create, read, update and/delete for a single Employee based on PK and return a status. Perhaps in grid table with drop down lists for Address and Roles (I want my cake and eat it too ??)

I'm learning C# and ASP.net on the fly. I have SQL experience and have taken VB & DBase college course in 2005, if there is an similar example code I feel confident I could go from there. If not, a list of 'to do's' will help. Many Thanks!

Tom

 


Answers (1)