i am building a site about attorneys i present the attorneys an one of the pages and when i click at the attorney pic he connect to the database and bring the information am searching for a way to view the attorneys at the page that if i deleted an attorneys from the database he will delete also i dunno if u r going to understand but try plz

i have a table "Grid View" (i think) and inside there is 4 cells in every cell there is a pic of the attorney and up to it his name when u click at the pic at will lead u to another page that contain an information about him(by the way the information is taken from a table called attorney in the DB), the problem that if for example an attorney retire or quite so i got to delete him i dont wanna open the visual studio again to delete his picture and his cell i have a table in the database 4 the attorneys that i can delete the attorney from their and all his information will be deleted so what i am askin is how can i view the attorney in which way that when  i want to delete HIM i a going to the DB directly not by deleting him from the DESINGER.???

You should use DataList or Repeater control to achieve showing 4 columns of records in a single row (the photos).  Why I didn't mention datagrid and gridview is because they do not allow you to repeat records in one row.  Look for the RepeatColumns property of the DataList.  If you are using any of the controls mentioned above, then you can get the data from the db and then bind it to the Dataaware controls.  From the db, you can get only the relevant informations (like leaving out the attorney's retired or who are no longer working for the firm).  Following is an example of SQL statement.

' Assumption if the attorney retires or no longer in the firm
' IsActive is set to 0
SELECT * FROM Attorneys WHERE IsActive = 1