• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

asp.net reference intigrity

I am new to asp.net
i have developed one web application using c# (Asp.net)

i have one citymaster.aspx and citymaster table.
user used to add record from citymaster.aspx in citymaster table.
in citymaster table i have three fields : cityid, cityname, is_deletestatus

when user enter new city record like (1, "NewYork", 'N')
Note : 'N' means record is active not deleted.

If some one deletes record from citymaster.aspx page, then instead of deleteing record physically from citymaster table i just used to change the is_deletestatus field to 'Y' (means that record is deleted)

now i also have studentmaster table in which i have cityid field.

so if someone used to delete city from citymaster then i need to check whether that city is allocated to any student record. if allocated then i dont even want to mark it 'Y'. (just as cascading constratint)

1 Solution
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:

You can add a query on delete action to get the count of students with city id. If the count is > 0 then there exists a student with the city.

You can add a code which does not let user to delete the record or simply gives alert to the user.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now