0

I use three fields in Sqlserver Datavbase tables, for prevent delete records permanently by user:

IsDelete (bit)
DeletedDate (DateTime)
DeletedUserID (bigint)

I wish to set third field (DeletedUserID) by UI by some thing like this:

        this.ExamdbDataSet.AcceptChanges();
        DataRowView row = (DataRowView)this.BindingSource.Current;
        row.BeginEdit();
        row["DeletedUserID"] = User.User.Current.ID;
        row.EndEdit();
        this.ExamdbDataSet.AcceptChanges();
        row.Delete();

and other two fields ,'IsDeleted' field and 'DeletedDate' are set automatically in table's 'After Delete Trigger'.

then commit changes to database with desire command successfuly with this code:

        this.TableAdapterManager.UpdateAll(this.ExamdbDataSet);

but problem is , the 'DeletedUserID' is null in database.

and Question is : How to set 'DeletedUserID' field value by true way in UI?

Yasser-Taherkhani
  • 45
  • 1
  • 1
  • 7

1 Answers1

0

I don't think it is a good way to do that. You have sliced a simple logic to separate parts, each being done in a different part of the application (UI, Trigger, ...). You set value of some field, and then DELETE the whole record! Don't expect anything else that the current situation. You would better set all fields in UI (i.e. no trigger in this case), and change the query that loads data. For example,

Select * from table1 where IsDeleted=0

You didn't tell us anything about whether your use ASP.Net or WinForms. Give us more info.

Delphi.Boy
  • 1,199
  • 4
  • 17
  • 38
  • I Use Winform and DataSetDesigner(Dataset,BindingSource,TableAdapter,BindingNavigator,...). I use above deleting code in 'DeleteButton_Click()' and then in after_Delete_trigger i insert deletd record in specify table. in this trigger i set "IsDeleted" and "DeletedDate" but i have to set "DeletedUserID" by UI. – Yasser-Taherkhani Dec 30 '13 at 08:05
  • Ok. Change the way you do it. Do it all in your UI, for example. – Delphi.Boy Dec 30 '13 at 10:49
  • a Problem is : Delete Check Constraints. In Database Sqlserver check constraints , if i want to do this at interface , i will have many defficaulty and problems. – Yasser-Taherkhani Dec 30 '13 at 11:02