Si se puede...
creas un objeto conexion, sqltransaccion, sqlcommand... mas o menos así
Código:
SqlConnection conn = new SqlConnection(conexion);
conn.Open();
SqlCommand Command;
SqlTransaction trans;
trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
Command = new SqlCommand("sentencia sql updtate",conn);
Command.Transaction=trans;
try
{
Command.ExecuteNonQuery();
trans.Commit();
}
catch
{
trans.Rollback();
}
finally
{
conn.Close();
}