The Source Code - Multilevel Security for Relational Databases - page 267

LowConnection.Open();
SqlCommand LowCommand =
LowConnection.CreateCommand();
LowTrans = LowConnection.
BeginTransaction();
Low Command.Connection =
LowConnection;
LowCommand.Transaction = LowTrans;
LowCommand.CommandText = “update MLS
set Salary = Salary where tc =
'Low' and Name not in (select top
300 Name from MLS)”;
LowCommand.ExecuteNonQuery();
for (int i = 1; i < = counter; i++)
{
LowCommand.CommandText = “update MLS
set Salary = Salary where tc =
'Low' and Name in (select top 300
Name from MLS)”;
LowCommand.ExecuteNonQuery();
}
LowTrans.Commit();
HighTrans.Commit();
Mes sageBox.Show(DateTime.Now.
Subtract(datepefor).ToString());
}
}
}}